December 17, 2008 at 6:07 am
I am trying to find a way to write a script or use the LogParser.exe so I can be emailed errors form the SQL Log as this server does not have a monitoring tool or anyone administering it on a full time basis. I have seen this done but my research has not really led me to what IO am looking for. I downloaded LogParser 2.2 from MS web site but you have to know the error you are looking for when you write your query string it looks like.
I would like to dso everything inside SQL like a job that scans the log and uses DatabaseMail to send out errors. Possibly load the log into a table and send email from that table (Just thinking out loud).
Any help or direction would be greatly appreciated.
Thanks
December 17, 2008 at 7:08 am
Might play arround with the built-in alerts that SQL has. In SSMS, drill into the SQL Server Agent node and right-click on the Alerts folder and click new alert.
It lets you do alerts by error number or severity, and you can also do alerts based on performance conditions.
Sounds like you aren't interested in doing things by error number, but would be more interested in severity. You may have to create a separate alert for each severity over 16 (or whatever number you choose).
The Redneck DBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply