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