sp_help_operator (T-SQL)

Reports information about the operators defined for the server.

Syntax

sp_help_operator [[@operator_name =] 'operator_name']
[,[@operator_id =] operator_id]

Arguments

[@operator_name =] 'operator_name': Is the operator name. operator_name is sysname. If operator_name is not specified, information about all operators is returned.
[@operator_id =] operator_id: Is the identification number of the operator for which information is requested. operator_id is int, with a default of NULL.

Return Code Values

0 (success) or 1 (failure)

Result Sets

Column name	Data type	Description
id	int	Operator identification number.
name	sysname	Operator Name.
enabled	tinyint	Operator is available to receive any notifications: 1 = Yes 0 = No
email_address	nvarchar(100)	Operator e-mail address.
last_email_date	int	Date the operator was last notified by e-mail.
last_email_time	int	Time the operator was last notified by e-mail.
pager_address	nvarchar(100)	Operator pager address.
last_pager_date	int	Date the operator was last notified by pager.
last_pager_time	int	Time the operator was last notified by pager.
weekday_pager_start_time	int	The start of the time period during which the operator is available to receive pager notifications on a weekday.
weekday_pager_end_time	int	The end of the time period during which the operator is available to receive pager notifications on a weekday.
Saturday_pager_start_time	int	The start of the time period during which the operator is available to receive pager notifications on Saturdays.
Saturday_pager_end_time	int	The end of the time period during which the operator is available to receive pager notifications on Saturdays.
Sunday_pager_start_time	int	The start of the time period during which the operator is available to receive pager notifications on Sundays.
Sunday_pager_end_time	int	The end of the time period during which the operator is available to receive pager notifications on Sundays.
pager_days	tinyint	A bitmask (1 = Sunday, 64 = Saturday) of days-of-the week indicating when the operator is available to receive pager notifications.
netsend_address	nvarchar(100)	Operator address for network pop-up notifications.
last_netsend_date	int	Date the operator was last notified by network pop-up.
last_netsend_time	int	Time the operator was last notified by network pop-up.
category_name	sysname	Name of the operator category to which this operator belongs.

Remarks

sp_help_operator must be run from the msdb database.

Permissions

Permissions to execute this procedure default to the sysadmin fixed server role and the db_owner fixed database role, who can grant permissions to other users.

Examples

This example reports information about operator andrewf.

USE msdb

EXEC sp_help_operator 'andrewf'

sp_add_operator	sp_update_operator
sp_delete_operator	System Stored Procedures