EnumAlerts Method
Dieses Feature wird in einer zukünftigen Version von Microsoft SQL Server entfernt. Verwenden Sie dieses Feature 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.