EnumNotifications List

SQLServer.Operator Object

Description

Lists the alert notifications for this Operator. List is returned in a QueryResults object.

Visual Basic

QueryResults = Operator.EnumNotifications (
[NotifyMethod :=] tNotify,
[AlertsToEnum :=] tAlerts,
[[OperatorName :=] strAlert] )

C++

HRESULT pOperator->EnumNotifications (
SQLOLE_NOTIFY_TYPE
tNotify,
SQLOLE_ENUMNOTIFY_TYPE
tAlerts,
LPSQLOLEQUERYRESULTS*
ppQueryResults,
SQLOLE_LPCSTR
strAlert = NULL );

Elements

Element Type Description

QueryResults QueryResults Returned QueryResults object
tNotify SQLOLE_NOTIFY_TYPE Type of notification to list
tAlerts SQLOLE_ENUMNOTIFY_TYPE Which alerts to list
strAlert String Specific alert. This parameter is used only when tAlerts 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