configure-sql-server-agent-mail-to-use-database-mail.md

description	Configure SQL Server Agent mail to use Database Mail
title	Configure SQL Server Agent mail to use Database Mail
ms.date	04/19/2022
ms.service	sql
ms.reviewer
ms.subservice
ms.topic	conceptual
helpviewer_keywords	Database Mail [SQL Server], SQL Server Agent Mail SQL Server Agent Mail
author	WilliamDAssafMSFT
ms.author	wiassaf
ms.custom	seo-dt-2019

Configure SQL Server Agent mail to use Database Mail

[!INCLUDE SQL Server]

This article describes how to configure [!INCLUDEssNoVersion] Agent to use Database Mail to send notification and alerts in [!INCLUDEssnoversion] by using [!INCLUDEssManStudioFull].

• For information on how to enable and configure Database Mail, see Configure Database Mail.
• For an example using [!INCLUDEtsql], see Create a Database Mail Profile.
• To send e-mail using SQL Agent jobs in [!INCLUDEssazuremi_md], 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 [!INCLUDEssNoVersion] Agent service account to use.

• Create a Database Mail profile for the [!INCLUDEssNoVersion] Agent service account to use and add the user to the DatabaseMailUserRole database role in the msdb database.

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

Using SQL Server Management Studio

The following steps are not necessary in [!INCLUDEssazuremi_md], 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 [!INCLUDEssNoVersion] 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
• Automate management tasks using SQL Agent jobs in Azure SQL Managed Instance