I'm having some issues with my send_dbmail recently on a SQL2005 server. For some reason, everything is being queued up and but not sent.
My Database Mail XPs run_value = 1
When i run EXEC msdb.dbo.sysmail_help_status_sp; the value is STARTED
When I run EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail'; the state is INACTIVE.
If i run
the state is still INACTIVE.