Microsoft_SQLServer_SystemJobs_Troubleshooter DataSource | Archive

Antony Hawkins · 2019-01-22T17:40:32Z

A hack of the Microsoft_SQLServer_SystemJobs datasource that will alert you in the event that the available credentials cannot gather SQL System Jobs. In brief, it attempts the same SQL query that the original DataSource runs, but creates no instances on a success - in the event of a failure, it will generate one instance whose description will be the error message, and one datapoint will be applied that will trigger a warning alert after a couple of minutes. It'll look a bit like this where the SQL query fails: Note this *only* tries the query for System Jobs ('select * from msdb.dbo.sysjobs') and I created this only when I noticed we were getting SQL database data, but not system jobs, from some customer devices. v1.1.0: 33H94M

MoreDiscussions

Microsoft_SQLServer_SystemJobs_Troubleshooter DataSource | Archive | LogicMonitor Community