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

How to find out who disabled/enabled a SQL agent job. Expand / Collapse
Author
Message
Posted Wednesday, December 4, 2013 8:27 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 10:34 AM
Points: 245, Visits: 345
Is there a way to find out who enabled or disabled a SQL server agent job?
Post #1519660
Posted Wednesday, December 4, 2013 9:26 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 7:33 AM
Points: 1,361, Visits: 15,264
No.

You could create a custom trigger on the msdb.dbo.sysjobs table to log when a change occurs.
Post #1519690
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse