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 Login to Claim
Nagios CSP

Meet The New Nagios Core Services Platform

Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.

Download Now

Monitoring Made Magically Better

  • Nagios Core on Overdrive
  • Powerful Monitoring Dashboards
  • Time-Saving Configuration Wizards
  • Open Source Powered Monitoring On Steroids
  • And So Much More!
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.
Helpful?    
Report
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.
Helpful?    
Report
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.
Helpful?    
Report
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?
Helpful?    
Report
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,301