Check MSSql Job Status

Submit review Recommend Print Contact Owner

Rating

0 votes

Favoured:

Current Version

1.0

Last Release Date

2012-01-19

Compatible With

Nagios 3.x

Owner

carlx

License

GPL

Hits

90163

Files:

File	Description
check_mssql_job_13082012.zip	check_mssql_job_13082012.zip

Network Monitoring Software - Download Nagios XI

Log Management Software - Nagios Log Server - Download

Netflow Analysis Software - Nagios Network Analyzer - Download

Plugin that checks mssql job last run outcome.It uses the sp_help_job procedure to get the job last tun outcome.

I added warning status when the job have warning icon in Job Agent.

The plugin requires php and freetds to connect SQL SERVER.
You can check http://www.peceny.de/misc/freetds.html for instructions how to configure php and freetds.

Usage:
check_mssql_job -H hostname -u username -p password -j jobname

-H the host name from freetds.conf
-u sql server user
-p ssql server user password
-j the name of the job from SQL Server Agent

User must be in sysadmin role or SQLAgentReaderRole on msdb.

Reviews (0)

Be the first to review this listing!

Nagios, the Nagios logo, and Nagios graphics are the servicemarks, trademarks, or registered trademarks owned by Nagios Enterprises. All other servicemarks and trademarks are the property of their respective owner. The files and information on this site are the property of their respective owner(s). Nagios Enterprises makes no claims or warranties as to the fitness of any file or information on this website, for any purpose whatsoever. In fact, we officially disclaim all liability. We do, however, think these community contributions are pretty damn cool. Website Copyright © 2009-2022 Nagios Enterprises, LLC. All rights reserved.