Monitoring for disabled SQL Server Agent jobs
Im looking into a requirement for SCOM to monitor and alert when a Windows SQL Agent Job becomes or is disabled. All of our jobs should be enabled to run and are disabled during maintenence periods but may be 'forgot' and left disabled. Many thanks Rob
May 16th, 2011 4:51am

Hi Rob, You can create a monitor for that. Check this for the example: http://www.simple-talk.com/sql/database-administration/monitor-your-database-backups-using-operations-manager/ http://OpsMgr.ru/
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2011 5:42am

The article is only concerned with SQl DB backups, i can't see about monitoring a SQL Agent Job for being disabled
May 16th, 2011 7:47am

you can use the same idea, you just have to write your own sql queries for SQL Agent Job.Rob Korving http://jama00.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2011 7:59am

Actually, the sql query for that can be very easy. Like this: USE msdb GO SELECT name, description from sysjobs WHERE enabled = 0http://OpsMgr.ru/
May 16th, 2011 9:53am

Hi, Please also try the methods in the following post: SQL Agent Job Discovery not working? http://blogs.technet.com/b/jimmyharper/archive/2009/06/05/sql-agent-job-discovery-not-working.aspx Hope this helps. Thanks. Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2011 5:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics