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