Home Directory Plugins Databases SQLServer Check SQL Agent Jobs Failed

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 SQL Agent Jobs Failed

Rating
0 votes
Favoured:
0
Current Version
1.0.0
Last Release Date
2014-05-27
Compatible With
  • Nagios 3.x
  • Nagios 4.x
License
GPL
Hits
29633
Files:
FileDescription
check_sqlJobs.vbscheck_sqlJobs.vbs
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!
You need to change the connection string with the name of the sql server you want to monitor, the password of the sa user and then implement the nrpe command and service on Nagios.
I use to execute this check only once per day in the morning.

define service{
use generic-service
host_name mysqlserver
servicegroups SqlAgentJobs
service_description Check SQL Agent Jobs on Failure
check_command check_sqlagent_jobs
check_period goodtime
contact_groups sqlmail
notifications_enabled 1
notification_interval 1440
notification_period goodtime
notification_options c,u
}
define command{
command_name check_sqlagent_jobs
command_line $USER1$/./check_nrpe -H $HOSTADDRESS$ -n -p 5666 -t 60 -c check_sql_jobs
}


you have to define in timeperiods.cfg the interval goodtime or use your own interval.