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.