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