Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Tracking a change to the notifications on an Agent job Expand / Collapse
Author
Message
Posted Monday, April 8, 2013 8:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 6, 2014 2:35 PM
Points: 49, Visits: 158
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
Post #1439875
Posted Monday, April 8, 2013 10:58 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 6:23 AM
Points: 392, Visits: 405
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

SQL Server Best Practices
Post #1439942
Posted Monday, April 8, 2013 11:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 6, 2014 2:35 PM
Points: 49, Visits: 158
That's good news! Any idea here to start?
Post #1439956
Posted Tuesday, April 9, 2013 8:44 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, October 16, 2014 6:18 PM
Points: 3,952, Visits: 7,170
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; They'll drag you down to their level and beat you with experience"


  Post Attachments 
TriggerForSendingEmail.txt (1 view, 2.38 KB)
Post #1440380
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse