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