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?

Answer 1

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

Answer 2

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.

Answer 3

I think we have answered this thread at the same time.!!

---

Thanks, Leks

Answer 4

Thanks for this! Helped me fix my issue. : )

Answer 5

Still helping 7 years later! Thanks!

Answer 6

Hi Justin,

I know this post is old... but thank you very much!  You are the man. :-)

Kelly

Answer 7

Thank you so much. It works now. 

---

Success is where preparation and opportunity meet.

Answer 8

Great, Thank You.

Answer 9

Thank you. it works