dbo.sysoperators (Transact-SQL)
Applies to:
SQL Server
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
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru