sysnotifications (Transact-SQL)
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  |