How do you use cloud databases? Take the survey.
Options
Can Monitor Report on Job or Schedule Changes?
BrainDonor
Friend of Redgate › Posts: 55 Silver 2
We've had a couple of changes to SQL jobs and schedules that we can't track back.
Is it possible to have Monitor raise a warning, if such things are changed?
I haven't seen anything in the documentation or examples that I've read.
Is it possible to have Monitor raise a warning, if such things are changed?
I haven't seen anything in the documentation or examples that I've read.
Tagged:
Answers
There is not a built-in alert for this, but could try to make a Custom Metric and look at msdb.dbo.sysjobs and or msdb.dbo.sysschedules (as they have a date_modified column). The issue is more that you would have to make a custom metric for each job or schedule unless you were just looking to see if any job or schedule had changed (at which point you would need to go check which it was manually).
Some of these other custom metrics dealing with jobs may give an idea of how to do this https://sqlmonitormetrics.red-gate.com/?s=job (particularly the "SQL Agent Jobs Owned By The Wrong Person" for the latter option above or "Job overran" for the former option).
Kind regards,
Alex
Have you visited our Help Center?