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

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
24347
Files:
FileDescription
check_sqlJobs.vbscheck_sqlJobs.vbs
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
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.