Freigeben über


EnumAlerts Method

Diese Funktion wird in zukünftigen Versionen von Microsoft SQL Server nicht mehr bereitgestellt. Verwenden Sie diese Funktion beim Entwickeln neuer Anwendungen nicht, und planen Sie das Ändern von Anwendungen, in denen es zurzeit verwendet wird.

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

Syntax

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);

Hinweise

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: