How do you use cloud databases? Take the survey.

Can Monitor Report on Job or Schedule Changes?

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.

Answers

  • Alex BAlex B Posts: 1,131 Diamond 4
    Hi @BrainDonor,

    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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • Thanks for the pointers. I'll have a closer look and let you know how I get on.
Sign In or Register to comment.