troubleshooting Question

Send send_dbmail

Avatar of gdspeare
gdspeare asked on
Microsoft SQL Server 2005Microsoft SQL Server 2008
6 Comments1 Solution488 ViewsLast Modified:
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

exec msdb.dbo.sysmail_stop_sp
exec msdb.dbo.sysmail_start_sp

the state is still INACTIVE.

Troubleshooting ideas?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros