Skip to content

database-mail-sending-test-email.md

Latest commit

 

History

History
58 lines (45 loc) · 3.08 KB

database-mail-sending-test-email.md

File metadata and controls

58 lines (45 loc) · 3.08 KB
title Send a Test Email with Database Mail
description Send a test email with database mail
author MashaMSFT
ms.author mathoma
ms.date 05/16/2025
ms.service sql
ms.topic how-to
helpviewer_keywords
architecture [SQL Server], Database Mail
Database Mail [SQL Server], architecture
Database Mail [SQL Server], components
monikerRange >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current

Send a test email with database mail

[!INCLUDE SQL Server SQL MI]

Use the Send Test E-Mail dialog box to test the ability to send mail using a specific profile.

Permissions

You must be a member of the sysadmin fixed server role to use the Send Test E-Mail dialog box. Users who are not members of the sysadmin fixed server role can test Database Mail using the sp_send_dbmail procedure.

Procedure

  1. Using Object Explorer in SQL Server Management Studio (SSMS), connect to an instance of SQL Server Database Engine where Database Mail is configured, expand Management, right-click Database Mail, and then select 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.

  2. In the Send Test E-Mail dialog box, in the Database Mail Profile box select the profile you want to test.

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

  4. 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.

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

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

  7. 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. Select OK.

  8. On the Toolbar select New Query to open a Query Editor window. Run the following T-SQL 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.

  9. 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> ;

Related content