---
title: "sp_notify_operator (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "08/09/2016"
ms.prod: sql
ms.prod_service: "database-engine"
ms.reviewer: ""
ms.technology: system-objects
ms.topic: "language-reference"
f1_keywords: 
  - "sp_notify_operator_TSQL"
  - "sp_notify_operator"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "sp_notify_operator"
ms.assetid: c440f5c9-9884-4196-b07c-55d87afb17c3
author: "stevestein"
ms.author: "sstein"
---
# sp_notify_operator (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]

  Sends an e-mail message to an operator using Database Mail.  
  
 
 ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)  
  
## Syntax  
  
```  
  
sp_notify_operator  
    [ @profile_name = ] 'profilename' ,  
    [ @id = ] id ,  
    [ @name = ] 'name' ,  
    [ @subject = ] 'subject' ,  
    [ @body = ] 'message' ,  
    [ @file_attachments = ] 'attachment'  
    [ @mail_database = ] 'mail_host_database'  
```  
  
## Arguments  
`[ @profile_name = ] 'profilename'`
 The name of the Database Mail profile to use to send the message. *profilename* is **nvarchar(128)**. If *profilename* is not specified, the default Database Mail profile is used.  
  
`[ @id = ] id`
 The identifier for the operator to send the message to. *id* is **int**, with a default of NULL. One of *id* or *name* must be specified.  
  
`[ @name = ] 'name'`
 The name of the operator to send the message to. *name* is **nvarchar(128)**, with a default of NULL. One of *id* or *name* must be specified.  
  
> **NOTE:** An e-mail address must be defined for the operator before they can receive messages.  
  
`[ @subject = ] 'subject'`
 The subject for the e-mail message. *subject* is **nvarchar(256)** with no default.  
  
`[ @body = ] 'message'`
 The body of the e-mail message. *message* is **nvarchar(max)** with no default.  
  
`[ @file_attachments = ] 'attachment'`
 The name of a file to attach to the e-mail message. *attachment* is **nvarchar(512)**, with no default.  
  
`[ @mail_database = ] 'mail_host_database'`
 Specifies the name of the mail host database. *mail_host_database* is **nvarchar(128)**. If no *mail_host_database* is specified, the **msdb** database is used by default.  
  
## Return Code Values  
 **0** (success) or **1** (failure)  
  
## Remarks  
 Sends the message specified to the e-mail address of the operator specified. If the operator has no e-mail address configured, returns an error.  
  
 Database Mail and a mail host database must be configured before a notification can be sent to an operator.  
  
## Permissions  
 By default, members of the **sysadmin** fixed server role can execute this stored procedure. Other users must be granted one of the following [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Agent fixed database roles in the **msdb** database:  
  
-   **SQLAgentUserRole**  
  
-   **SQLAgentReaderRole**  
  
-   **SQLAgentOperatorRole**  
  
 For details about the permissions of these roles, see [SQL Server Agent Fixed Database Roles](../../ssms/agent/sql-server-agent-fixed-database-roles.md).  
  
## Examples  
 The following example sends a notification e-mail to the operator `François Ajenstat` using the `AdventureWorks Administrator` Database Mail profile. The subject of the e-mail is `Test Notification`. The e-mail message contains the sentence, "This is a test of notification via e-mail."  
  
```  
USE msdb ;  
GO  
  
EXEC dbo.sp_notify_operator  
   @profile_name = N'AdventureWorks Administrator',  
   @name = N'François Ajenstat',  
   @subject = N'Test Notification',  
   @body = N'This is a test of notification via e-mail.' ;  
GO  
```  
  
## See also  
 [SQL Server Agent Stored Procedures (Transact-SQL)](../../relational-databases/system-stored-procedures/sql-server-agent-stored-procedures-transact-sql.md)   
 [sp_add_operator (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-add-operator-transact-sql.md)   
 [sp_help_operator (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-help-operator-transact-sql.md)   
 [sp_delete_operator (Transact-SQL)](../../relational-databases/system-stored-procedures/sp-delete-operator-transact-sql.md)