| title | dbo.sysnotifications (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | dbo.sysnotifications (Transact-SQL) | ||||
| author | VanMSFT | ||||
| ms.author | vanto | ||||
| ms.date | 03/04/2017 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
[!INCLUDE SQL Server]
Contains one row for each notification.
| Column name | Data type | Description |
|---|---|---|
| alert_id | int | ID of the alert. |
| operator_id | int | Operator ID to whom this notification should be sent. |
| notification_method | tinyint | Method of notification: 1 = E-mail 2 = Pager 4 = netsend 7 = All |