Troubleshooting Database Mail: Sending Test E-Mail

Using Object Explorer, connect to an instance of SQL Server Database Engine where Database Mail is configured, expand Management, right-click Database Mail, and then click Send Test E-Mail. If no Database Mail profiles exist, a dialog prompts the user to create a profile and opens the Database Mail Configuration Wizard.

In the Send Test E-Mail from <instance name> dialog box, in the Database Mail Profile box select the profile you want to test.

In the To box, type the e-mail name of the recipient of the test e-mail.

In the Subject box, type the subject line for the test e-mail. Change the default subject to better identify your e-mail for troubleshooting.

In the Body box, type to body of the test e-mail. Change the default subject to better identify your e-mail for troubleshooting.

Click Send Test E-Mail to send the test e-mail to the Database Mail queue.

Sending the test e-mail opens the Database Mail Test E-Mail dialog box. Make a note of the number displayed in the Sent e-mail box. This is the mailitem_id of the test message. Click OK.

On the Toolbar click New Query to open a Query Editor window. Execute the following statement to determine the status of the test e-mail message:

SELECT * FROM msdb.dbo.sysmail_allitems 
   WHERE mailitem_id = <the mailitem_id from the previous step> ;

The sent_status column indicates if the test e-mail message was sent.

If errors occurred, execute the following statement to view the error message:

SELECT * FROM msdb.dbo.sysmail_event_log 
   WHERE mailitem_id = <the mailitem_id from the previous step> ;