共用方式為


EnumNotifications Method

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The EnumNotifications method returns a QueryResults object that enumerates notifications for a Microsoft SQL Server Agent operator or alert.

語法


object
.EnumNotifications(
NotifyMethod 
,
EnumNotifyType 
,
[ AlertOrOperator ] ) as QueryResults

Parts

  • object
    Expression that evaluates to an object in the Applies To list.
  • NotifyMethod
    Long integer that specifies a notification method and directing result set construction as described in Settings.
  • EnumNotifyType
    Long integer that directs enumeration as described in Settings.
  • AlertOrOperator
    Optional. String that specifies a notification target or source by name. When using the AlertOrOperator argument, the EnumNotifyType argument must specify SQLDMOEnumNotify_Target.

Prototype (C/C++)

HRESULT EnumNotifications(
SQLDMO_NOTIFY_TYPE NotifyMethod,
SQLDMO_ENUMNOTIFY_TYPE EnumNotifyType,
LPSQLDMOQUERYRESULTS *ppResults,
SQLDMO_LPCSTR AlertOrOperator = NULL);

Settings

The NotifyMethod argument is a bit-packed long integer. Use an OR logical operator to specify more than a single value. Set the NotifyMethod argument using these values.

Constant Value Description

SQLDMONotify_All

7

Notification by e-mail, e-mail sent to the pager address, and network pop-up message.

SQLDMONotify_Email

1

Notification by e-mail sent to the operator e-mail address.

SQLDMONotify_NetSend

4

Notification by network pop-up message posted to the operator network address.

SQLDMONotify_Pager

2

Notification by e-mail sent to the operator pager address.

Set the EnumNotifyType argument using these values.

Constant Value Description

SQLDMOEnumNotify_/Actual

2

Return only those operators or alerts configured for notification.

SQLDMOEnumNotify_All

1

Return all operators or alerts. The value of the use_email, use_netsend, or use_pager column indicates that the operator or alert is configured for notification by the indicated method.

SQLDMOEnumNotify_Max

3

SQLDMOEnumNotify_Target.

SQLDMOEnumNotify_Min

1

SQLDMOEnumNotify_All.

SQLDMOEnumNotify_/Target

3

Return a result set that enumerates notification for the operator or alert specified in the AlertOrOperator argument.

Returns

For the Alert object, the EnumNotifications method returns a QueryResults object that contains one result set defined by these columns.

Column Data type Description

has_email

integer

When 1, the operator is configured with an e-mail address.

has_netsend

integer

When 1, the operator is configured with an address for network pop-up message receipt.

has_pager

integer

When 1, the operator is configured with a pager address.

operator_id

integer

System-generated operator identifier.

operator_name

nvarchar(129)

Operator name.

use_email

integer

Column present when NotifyMethod specifies SQLDMONotify_Email.

When 1, the operator is configured to receive notification by e-mail.

use_netsend

integer

Column present when NotifyMethod specifies SQLDMONotify_NetSend.

When 1, the operator is configured to receive notification by network pop-up message.

use_pager

integer

Column present when NotifyMethod specifies SQLDMONotify_Pager.

When 1, the operator is configured to receive notification by page.

For the Operator object, the EnumNotifications method returns a QueryResults object that contains one result set defined by these columns.

Column Data type Description

alert_id

integer

System-generated alert identifier.

alert_name

nvarchar(129)

Alert name.

has_email

integer

When nonzero, the number of operators configured to receive alert notification by e-mail.

has_netsend

integer

When nonzero, the number of operators configured to receive alert notification by network pop-up message.

has_pager

integer

When nonzero, the number of operators configured to receive alert notification by pager.

use_email

integer

Column present when NotifyMethod specifies SQLDMONotify_Email.

When 1, the alert is configured to raise notification by e-mail.

use_netsend

integer

Column present when NotifyMethod specifies SQLDMONotify_NetSend.

When 1, the alert is configured to raise notification by network pop-up message.

use_pager

integer

Column present when NotifyMethod specifies SQLDMONotify_Pager.

When 1, the alert is configured to raise notification by page.

Applies To:

Alert Object

Operator Object