Mail queued, not delivered

Category: sql server notification

Question

Mourmansk on Thu, 29 Nov 2012 00:39:47


Hi Everyone,

We have SQL SERVER 2008 R2,that it's Database Mail has stopped working.When I checked the sysmail_event_log,I found the following row:"The mail queue was started by login [UserName]." and there is not any other row."Sysmail_faileditems" shows all the test emails that I have tried have failed(They have status : failed).I checked the Service Broker is enabled (by running query Select is_broker_enabled from sys.databases where name ='msdb' )."View Database mail log"  does not show any error.

Is there any other thing that I have to check?

Thanks

Aspet


A.G


Replies

Iric Wen on Tue, 04 Dec 2012 06:43:37


Hi A.G,

After the Account and the Profile are created successfully, we need to configure the Database Mail. To configure it, we need to enable the Database Mail XPs parameter through the sp_configure stored procedure, as shown here:
 
sp_CONFIGURE 'show advanced', 1
 GO
 RECONFIGURE
 GO
 sp_CONFIGURE 'Database Mail XPs', 1
 GO
 RECONFIGURE
 GO

How do you find the Database Mail stopped working? I mean, the database mail is configured on your SQL Server agent job or other things?

Please read this article to check the steps of configuring database mail:

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

After all thing being configured, please send test mail in SQL Server Management studio or use sp_send_dbmail to see if it can drive successfully.

Thanks,


Iric Wen
TechNet Community Support