Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GregDDDD
Posting Yak Master
120 Posts |
 Posted - 2013-06-04 : 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 STARTEDWhen I run EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail'; I getmail 53 INACTIVE 2013-06-04 17:01:35.890 2013-06-04 17:01:35.890You 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?Greg |
|
|
GregDDDD
Posting Yak Master
120 Posts |
Posted - 2013-06-04 : 17:55:00
|
| DatabaseMail90.exe seems to have hung in memory. I killed the process from task manager and then sent a test email from SQL Server. The test email went and then the backlog of emails also went.Greg |
 |
|
|
|
|
|
DB Mail Suddenly Stopped Working