sysoperators (Transact-SQL)

Contains one row for each SQL Server Agent 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)

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

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

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

See Also

Other Resources