Job disabled..Event triggered

• M&M

  SSC-Insane

  Points: 21700

  More actions

  June 22, 2010 at 12:26 pm

  #143831

  There is a back up which got disabled. But now it is in enabled status.

  Is there a way by which we can find out who disabled this job from the default trace or DMVs.

  Also, if a job is disabled or enabled, what would be the event that is trigerred.

  M&M

• M&M

  SSC-Insane

  Points: 21700

  More actions

  June 22, 2010 at 12:54 pm

  #1183554

  I found answer for the second part of question (regarding event class when a job is disabled).

  These are below.

  SQL:BatchStarting

  EXEC msdb.dbo.sp_update_job @job_id=N'XXXXXXXXXXX',@enabled=0

  SQL:BatchCompleted

  EXEC msdb.dbo.sp_update_job @job_id=N'XXXXXXXXXXX', @enabled=0

  M&M