Creating a notification if SQLAgent service goes down or restarts.

  • 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.

  • 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...

  • 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.

  • 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