This documentation is archived and is not being maintained.

EnumAlerts Method

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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

object

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

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.

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.

Show: