sys.sp_help_notification

Description

Reports a list of alerts for a given operator or a list of operators for a given alert. The type of information to be returned. , which lists the alerts assigned to the supplied operator name, or which lists the operators responsible for the supplied alert name. , and can be one of these values.

Syntax

sp_help_notification
[ @object_type = ]
'object_type'
, [ @name = ]
N
'name'
, [ @enum_type = ]
'enum_type'
, [ @notification_method = ] notification_method
[ , [ @target_name = ]
N
'target_name'
]
[ ; ]