sysnotifications

Has a row for each notification.

Column Datatype Description
alert_id int The ID of the alert.
operator_id int The operator ID to whom this notification should be sent.
notification_method tinyint The method of notification (EMAIL, PAGER, BOTH).

Index

ByAlertIDAndOperator clustered, unique on alert_id, operator_id

Referenced by Stored Procedures

sp_addnotification sp_dropnotification sp_updatenotification
sp_dropalert sp_dropoperator