Skip to content

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

Latest commit

 

History

History
82 lines (51 loc) · 4.29 KB

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

File metadata and controls

82 lines (51 loc) · 4.29 KB
title Configure SQL Server Agent Mail to Use Database Mail
description Configure SQL Server Agent mail to use Database Mail
author WilliamDAssafMSFT
ms.author wiassaf
ms.date 05/16/2025
ms.service sql
ms.topic conceptual
helpviewer_keywords
Database Mail [SQL Server], SQL Server Agent Mail
SQL Server Agent Mail
monikerRange >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current

Configure SQL Server Agent mail to use Database Mail

[!INCLUDE SQL Server SQL MI]

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

Prerequisites

  1. Configure database mail.

  2. Create a Database Mail Account for the [!INCLUDEssNoVersion] Agent service account to use.

  3. 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. Verify that users properly configured to send mail.

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

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 to configure SQL Server Agent to use Database Mail

Tip

The following steps aren't 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.

The following steps use SQL Server Management Studio (SSMS)

  1. Connect to the [!INCLUDEssNoVersion] instance.

  2. In Object Explorer, expand a [!INCLUDEssNoVersion] instance.

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

  4. Select Alert System.

  5. Select Enable Mail Profile.

  6. In the Mail system list, select Database Mail.

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

  8. Restart SQL Server Agent.

Follow-up tasks

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

  • Alerts

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

  • Operators

    SQL Agent Operators are aliases for people or groups that can receive notifications, for example by email.

Related content