Monitoring the SQL Server Agent

• kingrudedog

  Mr or Mrs. 500

  Points: 529

  More actions

  September 24, 2013 at 9:57 am

  #283623

  We had an issue recently, where after patching the OS and rebooting, the SQL Agent hung:

  To clarify: All the jobs in the agent would start, and then run continuously without finishing.

  Is there a way to monitor the SQL Agent and send out an alert of there is hanging activity (for instance long running jobs - which would normally be monitoring by a job IN the Agent).

  I'm brainstorming here guys...

  Thanks,

  Rude Dog