How to find out who disabled/enabled a SQL agent job.

• Veteran Jones

  SSC Eights!

  Points: 937

  More actions

  December 4, 2013 at 8:27 am

  #279753

  Is there a way to find out who enabled or disabled a SQL server agent job?

• MysteryJimbo

  SSC-Insane

  Points: 24203

  More actions

  December 4, 2013 at 9:26 am

  #1670771

  No.

  You could create a custom trigger on the msdb.dbo.sysjobs table to log when a change occurs.