SQL Agent - Notification when Job Step Failed


  • Good day,

    I created an operator but i would like to send notification when a step within a jobs fails or completes.

    I see when viewing the history log - there is a notification column.

    When i on SQL Agent - New - Alert - then it does not allow me to specify a jb or mainly step within a job

    Well i would like to know when any steps fails whenever job runs.

    Please help - my operator is setup on Notification alerts
    Monday, March 15, 2010 1:52 PM


All replies