Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
New ListingsDirectory Tree
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
Hits
102962
You can view the README and checkout the repo from https://bitbucket.org/jetole/mssql-job-history/
Reviews (4)
byjshipe, March 5, 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.
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.
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?
