Database Mail

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.

February 5th, 2015 9:22pm

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

Free Windows Admin Tool Kit Click here and download it now
February 5th, 2015 9:51pm

which mail profile have you set in sql agent?
February 6th, 2015 1:30am

Hello,

You have to create Operators and add one to the Job notification; see Create an Operator

Free Windows Admin Tool Kit Click here and download it now
February 6th, 2015 3:11am

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.

February 6th, 2015 4:25am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics