SQLServer
MSSQL Job History
Description:
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/
Current Version
0.2
Last Release Date
2011-10-31
Compatible With
- Nagios 2.x
- Nagios 3.x
Owner
Download URL
License
GPL
Project Photos
Project Notes
Reviews
(4)
Add a Review
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.
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.
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.
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?
Page Sections
Project Stats
Rating
4.9 (7)
Favorites
5
Views
104,258