Post reply

Notification when a Job gets disabled.

  • September 5, 2012 at 2:22 pm

    #263817

    Hi everyone,

    Thanks for looking into my question.

    Is there a way to get notified when a SQL Server Agent job is disabled...?

    I logged into one of my production servers and was shocked to find that the backup job was disabled... so thought of finding out a way to get notified when a job is disabled.

    can you help..

    Regards,

    Siva.

  • September 5, 2012 at 2:54 pm

    #1534142

    There's nothing "built in" for this but there's no reason why you couldn't put an update trigger on msdb.dbo.sysjobs and msdb.dbo.sysschedules to send an email if the enabled flag is changed.

  • September 6, 2012 at 10:43 am

    #1534631

    Thank you. I have added a trigger for the same.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply