EnumNotifications List

SQLServer.Alert Object

Description

Lists the operator notifications for this Alert. List is returned in a QueryResults object.

Visual Basic

QueryResults = Alert.EnumNotifications (
[NotifyMethod :=] tNotify,
[OperatorsToEnum :=] tOperators,
[[OperatorName :=] strOperator] )

C++

HRESULT pAlert->EnumNotifications (
SQLOLE_NOTIFY_TYPE
tNotify,
SQLOLE_ENUMNOTIFY_TYPE
tOperators,
LPSQLOLEQUERYRESULTS*
ppQueryResults,
SQLOLE_LPCSTR
strOperator = NULL );

Elements

Element Type Description

QueryResults QueryResults Returned QueryResults object.
tNotify SQLOLE_NOTIFY_TYPE Type of notification to list.
tOperators SQLOLE_ENUMNOTIFY_TYPE Which operators to list.
strOperator String Specific operator. This parameter is used only when tOperators is SQLOLEEnumNotify_Target.

QueryResults

ColumnName ColumnType

operator_id SQLOLE_DTypeInt4
operator_name SQLOLE_DTypeChar
use_email SQLOLE_DTypeInt4
use_pager SQLOLE_DTypeInt4
has_email SQLOLE_DTypeBit
has_pager SQLOLE_DTypeBit

Reference

sp_helpnotification