none
SQL Server Agent Job Notifications Not Working

    Question

  • We have successfully setup Database Mail, and I am able to right click and 'Send Test E-Mail' and it works perfect. We have a few jobs setup in SQL Server Agent, and if the job fails it should e-mail us. Recently a job failed, but no e-mail. So I looked at the job log and see:

    NOTE: Failed to notify 'Development' via email.

    I confirm under Operators we have `Development` with the e-mail address I would like the error message to go to. Any ideas what would cause this?
    Tuesday, March 02, 2010 12:22 AM

Answers

  • Found the problem. Have to right click the SQL Server Agent and click properties. Then in that popup that is a place to enable notifications, and select Database Mail and the profile. Kind of hidden a bit, hopefully helps others.
    • Marked as answer by JustinK101 Tuesday, March 02, 2010 12:52 AM
    Tuesday, March 02, 2010 12:52 AM

All replies

  • Make sure you have set DBmail to be used for alerts in the agent profile. Right click SQL server agent  properties  Alert system  tick on Enable mail profile and choose Database mail and one of the mail profile and restart SQL agent.
    Thanks, Leks
    • Proposed as answer by Jason__Wang Thursday, July 24, 2014 8:05 AM
    Tuesday, March 02, 2010 12:52 AM
    Answerer
  • Found the problem. Have to right click the SQL Server Agent and click properties. Then in that popup that is a place to enable notifications, and select Database Mail and the profile. Kind of hidden a bit, hopefully helps others.
    • Marked as answer by JustinK101 Tuesday, March 02, 2010 12:52 AM
    Tuesday, March 02, 2010 12:52 AM
  • I think we have answered this thread at the same time.!!
    Thanks, Leks
    Tuesday, March 02, 2010 1:02 AM
    Answerer
  • Thanks for this! Helped me fix my issue. : )
    Friday, November 13, 2015 6:58 PM
  • Still helping 7 years later! Thanks!
    Thursday, April 06, 2017 3:13 PM