We help IT Professionals succeed at work.
Get Started

Unsent Emails In Database Mail Queue

7,819 Views
Last Modified: 2012-05-05
I created a Database Mail profile and account and successfully sent an email using the Database Mail Configuration Wizard.  I then created a Database Mail profile and account using sysmail_add_profile_sp, sysmail_add_account_sp, and sysmail_add_profileaccount_sp.  All went well until I attempted to send an email using the new profile.  SQL Server didn't throw any errors, but the email just got stuck in the queue.  I now have a bunch of emails stuck in the queue.  I've checked the following values:

1. Surface Area Configuration is enabled for DB Mail
2. As a member of sysadmin, my account is a member of msdb.DatabaseMailUserRole.
3. I confirmed that database mail is started.
4. The view sysmail_event_log isn't showing any errors.

It sure looks like the second profile/account pair I created is buggy.  How do I purge the contents of the queue to start fresh?
sysmail-mailitems.xls
Comment
Watch Question
QA Product Specialist
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE