sp_help_operator (Transact-SQL)
Applies to:
SQL Server
Reports information about the operators defined for the server.
Transact-SQL syntax conventions
Syntax
sp_help_operator
[ [ @operator_name = ] N'operator_name' ]
[ , [ @operator_id = ] operator_id ]
[ ; ]
Arguments
[ @operator_name = ] N'operator_name'
The operator name. @operator_name is sysname, with a default of NULL
. If @operator_name isn't specified, information about all operators is returned.
Either @operator_id or @operator_name must be specified, but both can't be specified.
[ @operator_id = ] operator_id
The identification number of the operator for which information is requested. @operator_id is int, with a default of NULL
.
Either @operator_id or @operator_name must be specified, but both can't be specified.
Return code values
0
(success) or 1
(failure).
Result set
Column name | Data type | Description |
---|---|---|
id |
int | Operator identification number. |
name |
sysname | Operator Name. |
enabled |
tinyint | Operator is available to receive any notifications:1 = Yes0 = 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
This stored procedure is owned by the db_owner role. You can grant EXECUTE
permissions for any user, but these permissions may be overridden during a SQL Server upgrade.
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.
Examples
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
Related content
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें