I am using SQL Server Management Studio V18. I would like to schedule a job in SQL agent, which will send some mail based on some condition. For that I have configured database account profile and I am trying to test the email. But email is not received. It is saying the below error. any help on this will appreciate.
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1002 (2021-03-30T05:36:55).
Exception Message: Cannot send mails to mail server (The operation has timed out
My suggestion is to either connect "in the clear" or use a custom or 3rd party program. This (maddening) issue has been with SQL Server for over a decade and, for us, it was because of using a secure connection (time outs - some mail never sent - yada yada). Our email server gets the connection credentials, so it IS communicating with it - (handshaking), but there's a bug with SSL when it comes time to deliver the message. Our solution was to create a CLR C# program that gets called and delivers messages correctly. You can look for a 3rd party emailer as well. SQL email will always disappoint.