Home Directory Plugins Databases SQLServer check_mssql_jobs.php

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_jobs.php

Rating
0 votes
Favoured:
0
Current Version
1.0
Last Release Date
2014-10-10
Compatible With
  • Nagios 1.x
  • Nagios 2.x
  • Nagios 3.x
  • Nagios 4.x
Owner
License
GPL
Hits
16523
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!
checks configured sql server for failed jobs (needs stored procedure 'sp_MonitorJobs' (which is located at my github account, see download URL)

-s server e.g. 'sql06'
-u username e.g. 'domaindbsnmp'
-p password e.g. '123foobar'
-e exclude e.g. 'jobname'
-h prints this text
checks configured sql server for failed jobs (needs stored procedure 'sp_MonitorJobs' (which is located at my github account, see download URL)

-s server e.g. 'sql06'
-u username e.g. 'domaindbsnmp'
-p password e.g. '123foobar'
-e exclude e.g. 'jobname'
-h prints this text


Exclude to be expected failed jobs with --exclude "CDW,FOO,BAR,BAZ" or disable them

Stored Procedure for SQL Server > 2000

https://github.com/riskersen/Monitoring/blob/master/mssql/sp_MonitorJobs_SQL200X.sql

Stored Procedure for SQL Server = 2000
https://github.com/riskersen/Monitoring/blob/master/mssql/sp_MonitorJobs_SQL2000.sql