Posting Yak Master
Posted - 06/04/2013 : 14:40:43
| Something happened on 5/31 that caused DB Mail to stop sending out emails.
When I run EXEC msdb.dbo.sysmail_help_status_sp The status is STARTED
When I run EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail'; I get
mail 53 INACTIVE 2013-06-04 17:01:35.890 2013-06-04 17:01:35.890
You can see there are 53 emails waiting to go out. From what I've read INACTIIVE is normal unless mail is actually being transmitted.
I can telnet to the mail server and send mail from the server running SQL Server. Even though no more mail goes out, I don't get anything in the DB Mail log after 5/31. The last error is below. I have two mail accounts set up for two different SMTP servers and both fail to send mail, but nothing new is written to the log.
The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2013-05-31T07:03:11). Exception Message: Cannot send mails to mail server. (The operation has timed out.).
I have restarted SQL Server Agent. Any ideas?