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
92082
Files:
FileDescription
check_mssql_job_13082012.zipcheck_mssql_job_13082012.zip
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.

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!
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.