I have setup DB mail on our SQL server 2012. There are 2 profiles and the 'Send test email' works for both.
I have set one of these profiles on a job but I am getting this error: -
Date 14/05/2018 09:38:30
Log Database Mail (Database Mail Log)
Log ID 295
Process ID 44936
Mail Item ID 101
Last Modified 14/05/2018 09:38:30
Last Modified By sa
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2018-05-14T09:38:30). Exception Message: Cannot send mails to mail server. (A recipient must be specified.).
Can anyone help?