Alert 멤버
The Alert class represents a Microsoft SQL Server Agent alert.
Alert 형식은 다음 멤버를 노출합니다.
생성자
| 이름 | 설명 | |
|---|---|---|
.gif "공용 메서드") |
Alert() () () () | Initializes a new instance of the Alert class. |
|
Alert(JobServer, String) | Initializes a new instance of the Alert class on the specified instance of SQL Server Agent and with the specified name |
맨 위로 이동
메서드
| 이름 | 설명 | |
|---|---|---|
.gif "보호된 메서드") |
AddDatabaseContext | (SqlSmoObject에서 상속됩니다.) |
|
AddNotification | Designates an operator that receives a notification message when the alert is raised. |
|
Alter | Updates any Alert object property changes on instance of Microsoft SQL Server . |
|
AlterImpl | (SqlSmoObject에서 상속됩니다.) |
|
AlterImplFinish | (SqlSmoObject에서 상속됩니다.) |
|
AlterImplInit | (SqlSmoObject에서 상속됩니다.) |
|
AlterImplWorker | (SqlSmoObject에서 상속됩니다.) |
|
BindDefaultImpl | (SqlSmoObject에서 상속됩니다.) |
|
BindRuleImpl | (SqlSmoObject에서 상속됩니다.) |
|
CheckCollation | (SqlSmoObject에서 상속됩니다.) |
|
CheckObjectState() () () () | Validates the state of the referenced object. (SqlSmoObject에서 상속됩니다.) |
|
CheckObjectState(Boolean) | Validates the state of the referenced object with the option to specify that an exception is thrown if the object is not yet created. (SqlSmoObject에서 상속됩니다.) |
|
CheckObjectStateImpl | (SqlSmoObject에서 상속됩니다.) |
|
CheckVersion100 | (SqlSmoObject에서 상속됩니다.) |
|
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (SqlSmoObject에서 상속됩니다.) |
|
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (SqlSmoObject에서 상속됩니다.) |
|
CheckVersion90 | Check the validity of the object on SQL Server 2005. (SqlSmoObject에서 상속됩니다.) |
|
CheckVersionBelow90 | (SqlSmoObject에서 상속됩니다.) |
|
CleanObject | (SqlSmoObject에서 상속됩니다.) |
|
Create | Creates an alert on the instance of Microsoft SQL Server as defined by the Alert object. |
|
CreateImpl | (SqlSmoObject에서 상속됩니다.) |
|
CreateImplFinish | (SqlSmoObject에서 상속됩니다.) |
|
CreateImplInit | (SqlSmoObject에서 상속됩니다.) |
|
Discover | (SqlSmoObject에서 상속됩니다.) |
|
Drop | Removes the alert. |
|
DropImpl | (SqlSmoObject에서 상속됩니다.) |
|
DropImplWorker | (SqlSmoObject에서 상속됩니다.) |
|
EnumNotifications() () () () | Enumerates a list of all notifications defined on the alert. |
|
EnumNotifications(String) | Enumerates a list of notification methods defined on the alert that are restricted to the specified operator. |
|
EnumNotifications(NotifyMethods) | |
|
EnumNotifications(NotifyMethods, String) | |
|
EnumScriptImpl | (SqlSmoObject에서 상속됩니다.) |
|
EnumScriptImplWorker | (SqlSmoObject에서 상속됩니다.) |
|
Equals | (Object에서 상속됩니다.) |
|
Finalize | (Object에서 상속됩니다.) |
|
FormatSqlVariant | (SqlSmoObject에서 상속됩니다.) |
|
GenerateDataSpaceFileStreamScript | (SqlSmoObject에서 상속됩니다.) |
|
GenerateDataSpaceScript | (SqlSmoObject에서 상속됩니다.) |
|
GetBindDefaultScript | (SqlSmoObject에서 상속됩니다.) |
|
GetBindRuleScript | (SqlSmoObject에서 상속됩니다.) |
|
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (SqlSmoObject에서 상속됩니다.) |
|
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (SqlSmoObject에서 상속됩니다.) |
|
GetDateTimeParameter | (SqlSmoObject에서 상속됩니다.) |
|
GetDateTimeParameterAsInt | (SqlSmoObject에서 상속됩니다.) |
|
GetDBName | Gets the database name that is associated with the object. (AgentObjectBase에서 상속됩니다.) |
|
GetEnumParameter | (SqlSmoObject에서 상속됩니다.) |
|
GetFragOptionString | (SqlSmoObject에서 상속됩니다.) |
|
GetGuidParameter | (SqlSmoObject에서 상속됩니다.) |
|
GetHashCode | (Object에서 상속됩니다.) |
|
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (SqlSmoObject에서 상속됩니다.) |
|
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (SqlSmoObject에서 상속됩니다.) |
|
GetPropValue | (SqlSmoObject에서 상속됩니다.) |
|
GetPropValueOptional | (SqlSmoObject에서 상속됩니다.) |
|
GetPropValueOptionalAllowNull | (SqlSmoObject에서 상속됩니다.) |
|
GetRealValue | (SqlSmoObject에서 상속됩니다.) |
|
GetScriptingOptionsForCreate | (SqlSmoObject에서 상속됩니다.) |
|
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (SqlSmoObject에서 상속됩니다.) |
|
GetServerObject | (SqlSmoObject에서 상속됩니다.) |
|
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (SqlSmoObject에서 상속됩니다.) |
|
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (SqlSmoObject에서 상속됩니다.) |
|
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (SqlSmoObject에서 상속됩니다.) |
|
GetTimeSpanParameterAsInt | (SqlSmoObject에서 상속됩니다.) |
|
GetType | (Object에서 상속됩니다.) |
|
GetUrnRecursive(StringBuilder) | (SqlSmoObject에서 상속됩니다.) |
|
GetUrnRecursive(StringBuilder, UrnIdOption) | (SqlSmoObject에서 상속됩니다.) |
|
ImplInitialize | (SqlSmoObject에서 상속됩니다.) |
|
Initialize() () () () | Initializes the object and forces the properties be loaded. (SqlSmoObject에서 상속됩니다.) |
|
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (SqlSmoObject에서 상속됩니다.) |
|
IsObjectDirty | Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of SQL Server. (SqlSmoObject에서 상속됩니다.) |
|
IsObjectInitialized | Verifies whether the object has been initialized. (SqlSmoObject에서 상속됩니다.) |
|
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (SqlSmoObject에서 상속됩니다.) |
|
IsVersion80SP3 | (SqlSmoObject에서 상속됩니다.) |
|
MarkDropped | (SqlSmoObject에서 상속됩니다.) |
|
MarkForDropImpl | (SqlSmoObject에서 상속됩니다.) |
|
MemberwiseClone | (Object에서 상속됩니다.) |
|
PostAlter | (SqlSmoObject에서 상속됩니다.) |
|
PostCreate | (SqlSmoObject에서 상속됩니다.) |
|
PostDrop | (SqlSmoObject에서 상속됩니다.) |
|
Refresh | Refreshes the object and retrieves properties when the object is next accessed. (SqlSmoObject에서 상속됩니다.) |
|
RemoveNotification | Removes the notification of an operator from the alert definition. |
|
Rename | Renames the alert. |
|
RenameImpl | This method supports the SMO infrastructure and is not intended to be used directly from your code. (NamedSmoObject에서 상속됩니다.) |
|
RenameImplWorker | This method supports the SMO infrastructure and is not intended to be used directly from your code. (NamedSmoObject에서 상속됩니다.) |
|
ResetOccurrenceCount | Resets the alert occurrence count back to zero. |
|
Script() () () () | Generates a Transact-SQL script that can be used to re-create the Microsoft SQL Server Agent alert. |
|
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the Microsoft SQL Server Agent alert as specified by the scripting options. |
|
ScriptAlter | (SqlSmoObject에서 상속됩니다.) |
|
ScriptChangeOwner | This method supports the SMO infrastructure and is not intended to be used directly from your code. (NamedSmoObject에서 상속됩니다.) |
|
ScriptCreate | (SqlSmoObject에서 상속됩니다.) |
|
ScriptDdl | (SqlSmoObject에서 상속됩니다.) |
|
ScriptDrop | (SqlSmoObject에서 상속됩니다.) |
|
ScriptImpl() () () () | (SqlSmoObject에서 상속됩니다.) |
|
ScriptImpl(ScriptingOptions) | (SqlSmoObject에서 상속됩니다.) |
|
ScriptImplWorker | (SqlSmoObject에서 상속됩니다.) |
|
ScriptRename | This method supports the SMO infrastructure and is not intended to be used directly from your code. (NamedSmoObject에서 상속됩니다.) |
|
SetParentImpl | (SqlSmoObject에서 상속됩니다.) |
|
ToString | Returns a String that represents the referenced object. (SqlSmoObject에서 상속됩니다.) |
|
TouchImpl | (SqlSmoObject에서 상속됩니다.) |
|
UnbindDefaultImpl | (SqlSmoObject에서 상속됩니다.) |
|
UnbindRuleImpl | (SqlSmoObject에서 상속됩니다.) |
|
UpdateNotification | Changes the notification method associated with an operator for the alert. |
|
Validate | (SmoObjectBase에서 상속됩니다.) |
맨 위로 이동
.gif "보호된 필드")
속성
| 이름 | 설명 | |
|---|---|---|
.gif "공용 속성") |
AlertType | Gets the AlertType object value that specifies the type of alert. |
|
CategoryName | Gets or sets the name of the category to which the alert belongs. |
|
CountResetDate | Gets or sets the date on which to reset the alert occurrence count back to zero. |
|
DatabaseName | Gets or sets the name of the database that the alert is monitoring. |
|
DelayBetweenResponses | Gets or sets the delay between responses in seconds. |
|
EventDescriptionKeyword | Gets or sets a word or phrase that must appear in the text of an event message that causes the alert to be raised. |
|
EventSource | Gets the event source text from the application event log. |
.gif "보호된 속성") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (SqlSmoObject에서 상속됩니다.) |
|
HasNotification | Gets the number of SQL Server Agent operators that are assigned to receive notification when the alert is fired. |
|
ID | Gets the ID value that uniquely identifies SQL Server Agent. |
|
IncludeEventDescription | Gets or sets the NotifyMethods object value that specifies the types of notification methods (e-mail, pager, or net send) that can contain alert error text. |
|
IsEnabled | Gets or sets the Boolean property value that specifies whether the alert is enabled or not. |
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (SqlSmoObject에서 상속됩니다.) |
|
JobID | Gets or sets the ID value of the SQL Server Agent job that is run in response to the alert being raised. |
|
JobName | Gets or sets the name of the SQL Server Agent job that is run in response to the alert being raised. |
|
LastOccurrenceDate | Gets or sets the date on which the alert was last raised. |
|
LastResponseDate | Gets or sets the date on which the alert last generated a response. |
|
MessageID | Gets or sets the ID value of the Microsoft SQL Server message that causes the alert to be raised. |
|
Name | Gets or sets the name of the object. (NamedSmoObject에서 상속됩니다.) |
|
NotificationMessage | Gets or sets the user-supplied text appended to any notification sent in response to an alert being raised. |
|
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (SqlSmoObject에서 상속됩니다.) |
|
OccurrenceCount | Gets the number of times the alert has fired since the alert was enabled or since a specified date. |
|
Parent | Gets or sets the JobServer object that is the parent of the Alert object. |
|
PerformanceCondition | Gets or sets the performance condition text. |
|
Properties | Gets a collection of Property objects that represent the object properties. (SqlSmoObject에서 상속됩니다.) |
|
ScalarResult | Gets the scalar result for the referenced object. (SqlSmoObject에서 상속됩니다.) |
|
Severity | Gets or sets the error message severity level that causes the alert to be raised. |
|
State | Gets the state of the referenced object. (SmoObjectBase에서 상속됩니다.) |
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (SqlSmoObject에서 상속됩니다.) |
|
UserData | Gets or sets user-defined data associated with the referenced object. (SmoObjectBase에서 상속됩니다.) |
|
WmiEventNamespace | Gets or sets the Windows Management Instrumentation (WMI) namespace for the event. |
|
WmiEventQuery | Gets or sets the Windows Management Instrumentation (WMI) query for the event. |
맨 위로 이동
이벤트
| 이름 | 설명 | |
|---|---|---|
.gif "공용 이벤트") |
PropertyChanged | (SqlSmoObject에서 상속됩니다.) |
|
PropertyMetadataChanged | (SqlSmoObject에서 상속됩니다.) |
맨 위로 이동
명시적 인터페이스 구현
| 이름 | 설명 | |
|---|---|---|
.gif "명시적 인터페이스 구현") .gif "전용 메서드") |
IAlienObjectDiscover | (SqlSmoObject에서 상속됩니다.) |
|
IAlienObjectGetParent | (SqlSmoObject에서 상속됩니다.) |
|
IAlienObjectGetProperty | (SqlSmoObject에서 상속됩니다.) |
|
ISfcPropertyProviderGetPropertySet | (SqlSmoObject에서 상속됩니다.) |
|
IAlienObjectGetUrn | (SqlSmoObject에서 상속됩니다.) |
|
IAlienObjectResolve | (SqlSmoObject에서 상속됩니다.) |
|
IAlienObjectSetProperty | (SqlSmoObject에서 상속됩니다.) |
맨 위로 이동