SQLServer

MSSQL Job History

Write a Review

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

Joseph "jetole" Tole

Website

https://bitbucket.org/jetole/mssql-job-history/

Download URL

https://bitbucket.org/jetole/mssql-job-history/

License

GPL

Copy Page Link Recommend Contact Owner Login to Add to Favorites
Project Photos
Project Notes
Reviews (4) Add a Review
Simple and straight-forward
by jshipe, March 31, 2014

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.


Some useful addons
by gigi19lic, January 31, 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.


Great Plugin!
by easy2kent, December 31, 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.


Question
by jbwaclawski, December 31, 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?


Add a Review

You must be logged in to submit a review.

Thank you for your review!

Your review has been submitted and is pending approval.

Recommend

To:


From:


Thank you for your recommendation!

Your recommendation has been sent.

Page Sections
Project Overview Project Photos Project Notes Reviews
Project Stats
Rating
4.9 (7)
Favorites
5
Views
104,256