TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

sp_help_operator (Transact-SQL)

 

Updated: August 1, 2016

Reports information about the operators defined for the server.

Topic link icon Transact-SQL Syntax Conventions

  
sp_help_operator  
     { [ @operator_name = ] 'operator_name'   
     | [ @operator_id = ] operator_id }  

[ @operator_name= ] 'operator_name'
The operator name. operator_name is sysname. If operator_name is not specified, information about all operators is returned.

[ @operator_id= ] operator_id
The identification number of the operator for which information is requested. operator_idis int, with a default of NULL.

System_CAPS_ICON_note.jpg Note


Either operator_id or operator_name must be specified, but both cannot be specified.

0 (success) or 1 (failure)

Column nameData typeDescription
idintOperator identification number.
namesysnameOperator Name.
enabledtinyintOperator is available to receive any notifications:

 1 = Yes

 0 = No
email_addressnvarchar(100)Operator e-mail address.
last_email_dateintDate the operator was last notified by e-mail.
last_email_timeintTime the operator was last notified by e-mail.
pager_addressnvarchar(100)Operator pager address.
last_pager_dateintDate the operator was last notified by pager.
last_pager_timeintTime the operator was last notified by pager.
weekday_pager_start_timeintThe start of the time period during which the operator is available to receive pager notifications on a weekday.
weekday_pager_end_timeintThe end of the time period during which the operator is available to receive pager notifications on a weekday.
saturday_pager_start_timeintThe start of the time period during which the operator is available to receive pager notifications on Saturdays.
saturday_pager_end_timeintThe end of the time period during which the operator is available to receive pager notifications on Saturdays.
sunday_pager_start_timeintThe start of the time period during which the operator is available to receive pager notifications on Sundays.
sunday_pager_end_timeintThe end of the time period during which the operator is available to receive pager notifications on Sundays.
pager_daystinyintA bitmask (1 = Sunday, 64 = Saturday) of days-of-the week indicating when the operator is available to receive pager notifications.
netsend_addressnvarchar(100)Operator address for network pop-up notifications.
last_netsend_dateintDate the operator was last notified by network pop-up.
last_netsend_timeintTime the operator was last notified by network pop-up.
category_namesysnameName of the operator category to which this operator belongs.

sp_help_operator must be run from the msdb database.

By default, members of the sysadmin fixed server role can execute this stored procedure. Other users must be granted one of the following SQL Server 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.

The following example reports information about operator François Ajenstat.

USE msdb ;  
GO  
  
EXEC dbo.sp_help_operator  
    @operator_name = N'François Ajenstat' ;  
GO  

sp_add_operator (Transact-SQL)
sp_delete_operator (Transact-SQL)
sp_update_operator (Transact-SQL)
System Stored Procedures (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Community Additions

ADD
Show:
© 2016 Microsoft