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