Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

On a SQL Server 2005 machine, I have DBMail setup and correctly configured. I am able to use "Notify Operator" and EXEC msdb.dbo.sp_send_dbmail to queue emails.

But the problem is the queued mails never go through. I see 10 emails in the queue when I query

SELECT * FROM msdb.dbo.sysmail_unsentitems

But if I restart the SQL Server service, all mails go through and I receive emails in my inbox.

So far this is the only pattern I could find.

So my question is: is there a way to troubleshoot DBmail? I read some steps on MSDN, but they are not of much help. Any URLs to articles that could help are much appreciated.

thanks,

share|improve this question

migrated from stackoverflow.com May 11 '11 at 8:19

This question came from our site for professional and enthusiast programmers.

add comment

1 Answer

Try this guide: http://msdn.microsoft.com/en-us/library/ms188663.aspx (You might want to check "Troubleshooting Database Mail: Mail queued, not delivered" section).

Otherwise, check the Event Viewer and post here the errors you find.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.