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
1.0
2014-10-10
- Nagios 1.x
- Nagios 2.x
- Nagios 3.x
- Nagios 4.x
GPL
16265
-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!