sysoperators (Transact-SQL)

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.