Skip to content

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

Latest commit

 

History

History
75 lines (47 loc) · 2.77 KB

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

File metadata and controls

75 lines (47 loc) · 2.77 KB
title Configure SQL Server Agent Mail to Use Database Mail | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology
ms.topic conceptual
helpviewer_keywords
Database Mail [SQL Server], SQL Server Agent Mail
SQL Server Agent Mail
ms.assetid 4b8b61bd-4bd1-43cd-b6e5-c6ed2e101dce
author stevestein
ms.author sstein
manager craigg

Configure SQL Server Agent Mail to Use Database Mail

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

Before You Begin

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

To configure SQL Server Agent to use Database Mail

  • In Object Explorer, expand a [!INCLUDEssNoVersion] 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.

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