How do I get dbmail to process items from the queue for SQL Server 2005?

Question :

How do I get dbmail to process items from the queue for SQL Server 2005?,

Answer :

When I use the sp_send_dbmail stored procedure, I get a message saying that my mail was queued. However, it never seems to get delivered. I can see them in the queue if I run this SQL:

SELECT * FROM msdb..sysmail_allitems WHERE sent_status = 'unsent'  

This SQL returns a 1:

SELECT is_broker_enabled FROM sys.databases WHERE name = 'msdb'  

This stored procedure returns STARTED:

msdb.dbo.sysmail_help_status_sp  

The appropriate accounts and profiles have been set up and the mail was functioning at one point. There are no errors in msdb.dbo.sysmail_event_log.

Read More  What rule engine should I use?

That’s the answer How do I get dbmail to process items from the queue for SQL Server 2005?, Hope this helps those looking for an answer. Then we suggest to do a search for the next question and find the answer only on our site.

Disclaimer :

The answers provided above are only to be used to guide the learning process. The questions above are open-ended questions, meaning that many answers are not fixed as above. I hope this article can be useful, Thank you

Read More  Best way to play MIDI sounds using C#