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
14248
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
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