Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
Directory Tree
check_mssql_jobs.php
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
14703
-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
-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
Reviews (0)
Be the first to review this listing!