Otherwise, you need to use a CMDexec job step calling PowerShell.exe. Also, to know the frequency for some messages can be valuable. Finally, I just wanted a good excuse to experiment with a new command, and this was a perfect project for that! When is it okay to exceed the absolute maximum rating on a part? this contact form
Its a great book and has lots of helpfull code. My central database, DBA_Rep, is housed on a SQL Server 2008 instance and contains all manner of tables in which to store various bits of useful SQL Server information. Figure 4 shows the SSIS Task Editor for the Create Temp Table for Error Logs task. You now see all messages except above, reducing the number of messages you see with each iteration. http://www.databasejournal.com/scripts/article.php/3518116/Import-the-SQL-Server-Error-Log-into-a-Table.htm
You have characters left. The columns should be ip address, -, User, date,url,status codes May 22, 2014 at 04:33 PM jonlellelid You can do it either in the LogParser query or load the whole row Phil Factor Re: reports … In the speech-bubble at the top of the page ssivaprasad SQL Server 2000 Error Log The article looks good.
Can you try to get it working on a non-clustered server to check it works?