dbmail is stopping sometimes in sql

129 Views Asked by At

sometimes dbmail in sql stops sending emails with this error: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2018-05-07T08:54:34). Exception Message: Cannot send mails to mail server. (A recipient must be specified.). ) and sometimes it does send. the above happens for all mail profiles, i tried everything, still the same. now i enabled one of the profile in sql server agent, it's working perfectly but the others are sometimes working and sometimes don't. please help!

1

There are 1 best solutions below

2
Sameer On

Verify recipient email id, it might be null or empty.