Lists the operator notifications for this Alert. List is returned in a QueryResults object.
QueryResults = Alert.EnumNotifications (
[NotifyMethod :=] tNotify,
[OperatorsToEnum :=] tOperators,
[[OperatorName :=] strOperator] )
HRESULT pAlert->EnumNotifications (
SQLOLE_NOTIFY_TYPE tNotify,
SQLOLE_ENUMNOTIFY_TYPE tOperators,
LPSQLOLEQUERYRESULTS* ppQueryResults,
SQLOLE_LPCSTR strOperator = NULL );
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. |
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 |
sp_helpnotification