Lists the alert notifications for this Operator. List is returned in a QueryResults object.
QueryResults = Operator.EnumNotifications (
[NotifyMethod :=] tNotify,
[AlertsToEnum :=] tAlerts,
[[OperatorName :=] strAlert] )
HRESULT pOperator->EnumNotifications (
SQLOLE_NOTIFY_TYPE tNotify,
SQLOLE_ENUMNOTIFY_TYPE tAlerts,
LPSQLOLEQUERYRESULTS* ppQueryResults,
SQLOLE_LPCSTR strAlert = NULL );
| 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. |
| 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