Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com

Login

Remember Me

Directory Tree

MSSQL Job History

Current Version
0.2
Last Release Date
2011-10-31
Compatible With
  • Nagios 2.x
  • Nagios 3.x
Owner
License
GPL
Hits
99142
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
MSSQL Job History
This is a simple script because I saw the idea of monitoring failed jobs at http://exchange.nagios.org/directory/Plugins/Databases/SQLServer/Check-MSSQL-Server-Centric-Status/details however I really didn't want to implement an unnecessarily complex, multi part, compiled java program on my nagios hosts to perform this same check. I added a couple features as well such as listing the failed jobs and the time they had last run as well as allowing you to specify a single job to check which will return OK|CRITICAL for that job alone.

You can view the README and checkout the repo from https://bitbucket.org/jetole/mssql-job-history/
Reviews (4)
Works as intended. Please note that this script requires Python >= 2.7 or >= 3.2. RHEL 5 does not support the Python argparse package out of the box. You'll either need to pull python-argparse from EPEL or install a different Python package.
bygigi19lic, January 21, 2014
You can add at the beginning of the SELECT 'SET rowcount 0', will eventually save some people, would of saved me :)

If you need it for the last hour, you can add something like the below at the end:

and [h].[run_time]>replace(CONVERT(VARCHAR(8),dateadd(hour,-1,getdate()),108),':','')


I have some jobs that when they fail, no matter if I fix the problem, I can't re-run them until next week, and I don't want to disble them and remember to enable them.
byeasy2kent, December 28, 2011
The plugin works like a charm now. I had some hiccups but the developer helped with the differences in my setup and made it work. Thanks for the great plugin. It actually works for checking MSSQL jobs and is accurate.
byjbwaclawski, December 16, 2011
This plugin looks pretty great. I"m still new to Nagios and can't quite figure out where to put it or how to use it. Mind helping me out?