September 6, 2005 at 1:03 pm
Hey all,
I know creating an Alert for SQLAgent shutdown/restarts will not work. Besides using 3rd party monitoring tools is there anything in Windows in particular Windows 2003 Server that I can use to send me a notification/alert if SQLAgent service goes down or restarted. Perhaps its triggered if it sees a event log in the Event Viewer. How would you approach this?
Thanks in advance.
September 7, 2005 at 7:33 am
You could write your own, but why are you not using the server vendor tools?
for example, dell server , dell tools
On a compaq server, you can set up (I forget how) a process monitor on sqlagent.exe using the compaq agents.
Unless you don't care about monitoring your servers.. or you are not using server hardware...
September 8, 2005 at 1:07 pm
If you have two SQL servers, you can set up a watchdog between them that will alert you if the other stops responding. It's worked well for me.
September 8, 2005 at 2:07 pm
Thanks guys for the reply.
Looking into Adam's suggestion.
Steve
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply