Home Directory Plugins Databases SQLServer Check MSSql Job Status

Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com

Login

Remember Me

Directory Tree

Check MSSql Job Status

Rating
0 votes
Favoured:
0
Current Version
1.0
Last Release Date
2012-01-19
Compatible With
  • Nagios 3.x
Owner
License
GPL
Hits
89098
Files:
FileDescription
check_mssql_job_13082012.zipcheck_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.