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