sysoperators (Transact-SQL)
Contains one row for each SQL Server Agent operator.
Column name |
Data type |
Description |
|---|---|---|
id |
int |
ID of the operator. |
name |
sysname |
Name of the operator. |
enabled |
tinyint |
Status of alert notifications (Boolean). If 1, this operator can receive notifications when an alert occurs. |
email_address |
nvarchar(100) |
E-mail address for this operator. |
last_email_date |
int |
Date this operator last received an e-mail alert notification. |
last_email_time |
int |
Time of day this operator last received an e-mail alert notification. |
pager_address |
nvarchar(100) |
Pager address for this operator. |
last_pager_date |
int |
Date this operator last received a pager alert notification. |
last_pager_time |
int |
Time of day this operator last received a pager alert notification. |
weekday_pager_start_time |
int |
Time of day on a weekday (Monday through Friday) after which this operator is available to receive a pager alert notification. |
weekday_pager_end_time |
int |
Time of day on a weekday (Monday through Friday) after which this operator is not available to receive a pager alert notification. |
saturday_pager_start_time |
int |
Time of day on Saturday after which this operator is available to receive a pager alert notification. |
saturday_pager_end_time |
int |
Time of day on Saturday after which this operator is not available to receive a pager alert notification. |
sunday_pager_start_time |
int |
Time of day on Sunday after which this operator is available to receive a pager alert notification. |
sunday_pager_end_time |
int |
Time of day on Sunday after which this operator is not available to receive a pager alert notification. |
pager_days |
tinyint |
Bitmask representing the days of the week during which this operator is available to receive a pager alert notification. |
netsend_address |
nvarchar(100) |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |
last_netsend_date |
int |
Date that the most recent network message was last sent to the specified operator ID. |
last_netsend_time |
int |
Time that the most recent network message was last sent to the specified operator ID. |
category_id |
int |
Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. |