Contains one row for each operator.
| Column | Datatype | Description |
|---|---|---|
| id | int | The ID of the operator. |
| name | varchar(50) | The name of the operator. |
| enabled | tinyint | The status of alert notifications (Boolean). If 1, this operator can receive notifications when an alert occurs. |
| email_address | varchar(100) | The e-mail address for this operator. |
| last_email_date | int | The date this operator last received an e-mail alert notification. |
| last_email_time | int | The time of day this operator last received an e-mail alert notification. |
| pager_address | varchar(100) | The pager address for this operator. |
| last_pager_date | int | The date this operator last received a pager alert notification. |
| last_pager_time | int | The time of day this operator last received a pager alert notification. |
| weekday_pager_start_time | int | The 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 | The 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 | The time of day on Saturday after which this operator is available to receive a pager alert notification. |
| saturday_pager_end_time | int | The time of day on Saturday after which this operator is not available to receive a pager alert notification. |
| sunday_pager_start_time | int | The time of day on Sunday after which this operator is available to receive a pager alert notification. |
| sunday_pager_end_time | int | The time of day on Sunday after which this operator is not available to receive a pager alert notification. |
| pager_days | tinyint | Bitmask. The days of the week during which this operator is available to receive a pager alert notification. |
ByName clustered, unique on name
ByID nonclustered, unique on id
| sp_addnotification | sp_helphistory | sp_schedulerrefresh |
| sp_addoperator | sp_helpnotification | sp_updatenotification |
| sp_dropnotification | sp_helpoperator | sp_updateoperator |
| sp_dropoperator | sp_helptask | sp_verifytask |