sysoperators

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.

Index

ByName clustered, unique on name
ByID nonclustered, unique on id

Referenced by Stored Procedures

sp_addnotification sp_helphistory sp_schedulerrefresh
sp_addoperator sp_helpnotification sp_updatenotification
sp_dropnotification sp_helpoperator sp_updateoperator
sp_dropoperator sp_helptask sp_verifytask