Post reply

Tracking a change to the notifications on an Agent job

  • April 8, 2013 at 8:34 am

    #291920

    Hi everyone,

    So I've had someone change the notifications, specifically the Page: nofitication on all agent jobs on our production server. It's easy enough to change this back to it's correct value but I'm wondering who did it. Do these get logged anywhere by default, or do I have to enable logging in some way to catch it in the future (which does me no good on this instance). Thanks

  • April 8, 2013 at 10:58 am

    #1604501

    I am afraid that you will be able to find the culprit

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • April 8, 2013 at 11:36 am

    #1604513

    That's good news! Any idea here to start?

  • April 9, 2013 at 8:44 am

    #1604859

    Place trigger on the msdb..sysjobs table for each server you wish to monitor - something like the code attached will work, just add in the statements to check the INSERTED table and it should be fine. The attached SQL is for emailing when someone enables/disables a SQL Agent job

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

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

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