Forum Discussion

Antony_Hawkins's avatar
6 years ago

Microsoft_SQLServer_SystemJobs_Troubleshooter DataSource

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