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 |