SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 DB Mail Suddenly Stopped Working
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

GregDDDD
Posting Yak Master

120 Posts

Posted - 06/04/2013 :  14:40:43  Show Profile  Reply with Quote
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?

Greg

GregDDDD
Posting Yak Master

120 Posts

Posted - 06/04/2013 :  17:55:00  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000