Transact-SQL Reference
sysoperators
Contains one row for each 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) | Reserved. |
| 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 | Reserved. |