Share via

EnumAlerts Method

  • 아티클

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The EnumAlerts method returns a QueryResults object that enumerates the Microsoft SQL Server Agent alerts that cause automated execution of the referenced job.

구문

object
.EnumAlerts( )
as 
QueryResults

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

Returns

A QueryResults object that contains one result set defined by these columns.

Column Data type Description

enabled

tinyint

When 1, the alert is enabled.

id

integer

System-generated alert identifier.

name

nvarchar(129)

Alert name.

type

integer

Identifies the alert source as described in Remarks.

Prototype (C/C++)

HRESULT EnumAlerts(LPSQLDMOQUERYRESULTS* ppResults);

주의

The result set column type identifies the alert source. When 1, the alert is raised in response to a SQL Server event. When 2, the alert is raised when a monitored performance condition is exceeded.

Applies To:

Job Object