DESCRIPTION:
Sometimes people want to know if one of their co-workers or subordinates disabled a SQL job.
INSTRUCTIONS:
Download the datasource file and add it into to LogicMonitor (Settings > Datasources > Add > From file)
It should alert you if enabled is not 1. If you want to ignore some jobs, just click on that instance and turn off alerting or monitoring.
It’s set to use Windows Integrated Authentication but if you want to use SQL authentication, you can change the datasource and specifying a SQL username and password.
NOTES:
I did this with a datasource that uses JDBC collection type to run a SQL query on the database to list the jobs and show those job names as instances. The collection portion of datasource runs another SQL query for each of those jobs to retrieve the current setting for “enabled”.
No comments