Search All Sites
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.
- Nagios 2.x
- Nagios 3.x
You can view the README at https://github.com/jetole/MSSQL-Job-History
You can view the history / changelog at https://github.com/jetole/MSSQL-Job-History/commits/master/check_mssql_job_history.py
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.