Export (0) Print
Expand All
Expand Minimize

sysoperators

SQL Server 2000

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft