How can we help you today? How can we help you today?

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.
BrainDonor
0

Comments

2 comments

Sort by
  • Alex B
    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
    Alex B
    0
  • BrainDonor
    Thanks for the pointers. I'll have a closer look and let you know how I get on.
    BrainDonor
    0

Add comment

Please sign in to leave a comment.