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
16415
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!
-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!