SQL Server Performance Forum – Threads Archive
Not Receiving Database Mail when Job FailsHello, I have configured the database mail and everything was working fine. Yestarday I had restarted the sql server and also set the service broker. When a job fails , I am not receiving any notification. What should I do or check. Thanks
Did you configure SQL Agent mail?
If not enable the MAIL SESSION in SQL Agent properties. Mohammed U.
Check thishttp://msdn2.microsoft.com/en-us/ms186358.aspx and ensure everything is setup properly.
Make sure HTTP endpoint is enabled. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.