wantto Enable Notify Level for Log shipping jobs when they Fail


  • You cannot vote on your own post

    As we are facing issues with Alerts, as they are not Firing Alerts on Failures and writting Application Logs, Can some Provide script to enable Notifications to write Applucation error logs when Log shipping job fails, Please find below script to obatain information for which jobs Notifications are not enabled when Job Fails


          name AS JobName

          , "Enabled" =


                      WHEN enabled=1 THEN 'Yes'

                      WHEN enabled=0 THEN 'No'


          ,notify_level_eventlog AS NotifyLevelEventLog

          , "Description" =


                      WHEN notify_level_eventlog=0 THEN 'No Logging'

                      WHEN notify_level_eventlog=1 THEN 'Log Success'

                      WHEN notify_level_eventlog=2 THEN 'Log on Failure'

                      WHEN notify_level_eventlog=3 THEN 'Log on Either Result'


    FROM msdb..sysjobs WITH (NOLOCK)



    martedì 24 aprile 2012 08:45

Tutte le risposte

  • Hello Maddy,

    Have you enabled the Notification? For example, look at this post.

    SKG: Please Marked as Answered, if it resolves your issue. (b:

    martedì 24 aprile 2012 11:11
  • You need to enable the Alert System in SQL Server Agnet

    SQL Server Agent --> Properties --> Alert System --> mark in enable mail profile --> Mail System (Select Profile which you cretaed during Database Mail configuration)--> Restart SQL Server Agent.

    Plus You need to enable the same for alert job.

    Log Shipping Alert job name --> Properties --> Notification --> Email (operator) then select the status..


    • Contrassegnato come risposta maddy28 martedì 24 aprile 2012 14:34
    • Contrassegno come risposta annullato maddy28 martedì 24 aprile 2012 14:34
    martedì 24 aprile 2012 13:13
  • Hi maddy28,

    Do the suggestions above not work for you? Could you please elaborate on your scenario a bit more?


    Stephanie Lv

    TechNet Community Support

    mercoledì 25 aprile 2012 06:52