none
Email alerts for failed SQL Agent jobs

    Question

  • Hello,

    I have SCE monitoring all our SQL database servers and have email alerts set up to notify me when a SQL agent on those servers fail.  Last week we had a database backup job within an agent fail and I did not receive an email alert.  I noticed that SCE did generate an alert and when I click on the actual monitor listed to go into that monitor's properties, there is no where to configure that monitor to generate email alerts.  Is there somewhere in SCE where I can have it generate email alerts when these backup jobs fail?

    Thanks.

    Monday, June 09, 2008 5:17 PM

Answers

All replies

  • Hi,

     

    You need to enable email notification channel and subscribe this alert notification. Please refer to following:

     

    http://technet.microsoft.com/en-us/library/bb309501(TechNet.10).aspx

     

    Hope it helps.
    Wednesday, June 11, 2008 3:53 AM
  • I already have the email notifications configured properly.  My issue is whenever I have a job fail within an agent (such as a transaction log backup), an error is generated in SCE but I do not receive an email alert for it.  When I examine the monitor that generated that alert I can't find anywhere to configure email notification through that monitor.  If the acutal SQL agent fails or something else goes wrong in SQL then I receive email alerts through SCE so I know the actual email notifications is working fine.

    Thursday, June 12, 2008 1:14 PM
  • Hi,

     

    Have you subscribed notification for relevant alerts from administration-notifications->subscription? If not, you will not receive alerts email. Also, Note enable custom subscription in right-hand page.

     

    More information:

     

    http://technet.microsoft.com/en-us/library/bb309608(TechNet.10).aspx

     

    Hope this helps.

    Friday, June 13, 2008 3:34 AM