Why isn't SQL Server 2005 processing queued dbmail items?

Data and Databases
1

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?

2

yo, have u checked if the SQL Server Agent is running? sometimes it gets stopped n that messes up dbmail. also, might wanna look at the mail queue using sp_sysmail_activate_subsystem. if that doesn’t help, try restarting the database engine. those usually fix weird dbmail issues for me

3

hey there! have u tried checkin the firewall settings? sometimes they can block outgoing mail. also, whats ur antivirus situation? ive seen AV programs interfere with dbmail before. maybe try disabling it temporarily? oh and hows ur network connectivity? any recent changes there? just brainstormin some ideas for ya!