Post reply

Job disabled..Event triggered

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

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