Configure SQL Server Agent Mail to Use Database Mail
This topic describes how to configure SQL Server Agent to use Database Mail to send notification and alerts in SQL Server 2014 by using SQL Server Management Studio.
Before you begin:
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 in the msdb database.
Set the profile as the default profile for the msdb database.
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.