dbo.sysoperators (Transact-SQL)
Applies to: 
SQL Server
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. |