Configure SQL Server Agent mail to use Database Mail

Applies to: SQL Server

This article describes how to configure SQL Server Agent to use Database Mail to send notification and alerts in SQL Server 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.
• To send e-mail using SQL Agent jobs in Azure SQL Managed Instance, SQL Server Agent can use only one Database Mail profile, and it must be called AzureManagedInstance_dbmail_profile. For more information and a sample script, see Azure SQL Managed Instance SQL Agent job notifications.

Prerequisites

• Enable Database Mail.

• Create a Database Mail account for the SQL Server Agent service account to use.

• Create a Database Mail profile for the SQL Server Agent service account to use and add the user to the DatabaseMailUserRole database role in the msdb database. For instructions, see Are users properly configured to send mail.

• Set the profile as the default profile for the msdb database.

Security

Permissions

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

Use SQL Server Management Studio

The following steps aren't necessary in Azure SQL Managed Instance, which is already configured to look for a profile called AzureManagedInstance_dbmail_profile. For more information and a sample script, see Azure SQL Managed Instance SQL Agent job notifications.

To configure SQL Server Agent to use Database Mail in SQL Server

• In Object Explorer, expand a SQL Server instance.

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

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

Follow-up Tasks

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

Next steps

• Configure Database Mail
• Configure SQL Server Agent
• General database mail troubleshooting steps
• Automate management tasks using SQL Agent jobs in Azure SQL Managed Instance