This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Managed Instance
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.
AzureManagedInstance_dbmail_profile. For more information and a sample script, see Azure SQL Managed Instance SQL Agent job notifications.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. Verify that users properly configured to send mail.
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.
Tip
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.
The following steps use SQL Server Management Studio (SSMS)
Connect to the SQL Server instance.
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.
The following tasks are necessary to complete the configuration of Agent to send alerts and notifications.
SQL Agent Alerts can be configured to notify an operator of a particular database event or operating system condition.
SQL Agent Operators are aliases for people or groups that can receive notifications, for example by email.
Training
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.