Configure SQL Server Agent Mail to Use Database Mail


Updated: August 5, 2016

Applies To: SQL Server 2016

This topic describes how to configure SQL Server Agent to use Database Mail to send notification and alerts in SQL Server 2016 by using SQL Server Management Studio. For information on how to enable and configure Database Mail, see Configure Database Mail. For an example using Transact-SQL, see Create a Database Mail Profile.




The user creating the profiles accounts and executing stored procedures should be a member of the sysadmin fixed server role.

To configure SQL Server Agent to use Database Mail

  • In Object Explorer, expand a SQL Server instance.

  • Right-click SQL Server Agent, and then click Properties.

  • Click Alert System.

  • Select Enable Mail Profile.

  • In the Mail system list, select Database Mail.

  • In the Mail profile list, select a mail profile for Database Mail.

  • Restart SQL Server Agent.

The following tasks are necessary to complete the configuration of Agent to send alerts and notifications.

  • Alerts

    Alerts can be configured to notify an operator of a particular database event or operating system condition.

  • Operators

    Operators are aliases for people or groups that can receive electronic notification

Community Additions