Post reply

SQL Server Agent Job

  • April 2, 2015 at 3:01 pm

    #302724

    How to configure alert when SQL Server Agent Job gets disabled. I want to get notified when Agent Job gets disabled. Let me know if you have done something similar to this?

    Thanks

  • April 3, 2015 at 7:54 am

    #1788548

    Admingod (4/2/2015)

    How to configure alert when SQL Server Agent Job gets disabled. I want to get notified when Agent Job gets disabled. Let me know if you have done something similar to this?

    Thanks

    Done similar using the dbo.sysjobs table in the msdb via stored procedure and hooking it into the monitoring.

    😎

  • April 3, 2015 at 2:22 pm

    #1788677

    Ok thanks! This helps, I have created Job and alert me if row count > 0 from sysjobs table.

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

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