SQLServer

Check SQL Agent Jobs Failed

Description:

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.

Current Version

1.0.0

Last Release Date

2014-05-27

Compatible With

  • Nagios 3.x
  • Nagios 4.x

Owner

License

GPL


Project Files
Project Notes
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.
Reviews (0) Add a Review
Add a Review

You must be logged in to submit a review.

Thank you for your review!

Your review has been submitted and is pending approval.

Recommend

To:


From:


Thank you for your recommendation!

Your recommendation has been sent.

Project Stats
Rating
0 (0)
Favorites
0
Views
29,557