Hi,
I did configuration of Database Mail and sent an test email and got the message.
My problem is I have SQL Server Agent Job that sends emails when the job is failed. I did not get the email when the job failed. Why?
Thanks.
Technology Tips and News
Hi,
I did configuration of Database Mail and sent an test email and got the message.
My problem is I have SQL Server Agent Job that sends emails when the job is failed. I did not get the email when the job failed. Why?
Thanks.
Hello
Try sp_send_dbmail from SSMS first. If works then you must make sure that the agent is configure to use the proper database mail profile
https://msdn.microsoft.com/en-us/library/ms190307.aspx
https://msdn.microsoft.com/en-us/library/ms186358.aspx
Hope it helps
Regards
Hello,
You have to create Operators and add one to the Job notification; see Create an Operator
As Visakh noted, you need to configure what mail Profile that Agent should use, or you won't get any emails! And after that you need to re-start the Agent service.
And also create operators, of course.