I’m having trouble with dbmail in SQL Server 2005. I use sp_send_dbmail
and it says the mail is queued. But nothing gets sent. I can see unsent items in msdb..sysmail_allitems
.
The broker is enabled for msdb and the mail status shows as STARTED. I’ve set up accounts and profiles. It worked before, but now it’s stuck.
Here’s what I’ve checked:
-- This shows unsent items
SELECT * FROM msdb..sysmail_allitems WHERE sent_status = 'unsent'
-- This returns 1
SELECT is_broker_enabled FROM sys.databases WHERE name = 'msdb'
-- This returns STARTED
EXEC msdb.dbo.sysmail_help_status_sp
No errors in msdb.dbo.sysmail_event_log
. Any ideas why the queue isn’t processing?