Creating a notification if SQLAgent service goes down or restarts.

• Steve Velasco

  Old Hand

  Points: 332

  More actions

  September 6, 2005 at 1:03 pm

  #110276

  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.

• gbn

  SSCertifiable

  Points: 6429

  More actions

  September 7, 2005 at 7:33 am

  #588079

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

• Adam Caswell

  Grasshopper

  Points: 17

  More actions

  September 8, 2005 at 1:07 pm

  #588521

  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.

• Steve Velasco

  Old Hand

  Points: 332

  More actions

  September 8, 2005 at 2:07 pm

  #588541

  Thanks guys for the reply.

  Looking into Adam's suggestion.

  Steve