Alert 类

The Alert class represents a Microsoft SQL Server Agent alert.

命名空间:  Microsoft.SqlServer.Management.Smo.Agent
程序集:  Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)

语法

声明
Public NotInheritable Class Alert _
    Inherits AgentObjectBase _
    Implements ICreatable, IDroppable, IAlterable, IRenamable,  _
    IScriptable
用法
Dim instance As Alert
public sealed class Alert : AgentObjectBase, 
    ICreatable, IDroppable, IAlterable, IRenamable, IScriptable
public ref class Alert sealed : public AgentObjectBase, 
    ICreatable, IDroppable, IAlterable, IRenamable, IScriptable
[<SealedAttribute>]
type Alert =  
    class
        inherit AgentObjectBase
        interface ICreatable
        interface IDroppable
        interface IAlterable
        interface IRenamable
        interface IScriptable
    end
public final class Alert extends AgentObjectBase implements ICreatable, IDroppable, IAlterable, IRenamable, IScriptable

Alert 类型公开以下成员。

构造函数

  名称 说明
公共方法 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

页首

属性

  名称 说明
公共属性 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.
受保护属性 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.

页首

方法

  名称 说明
受保护方法 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 继承。)

页首

事件

  名称 说明
公共事件 PropertyChanged (从 SqlSmoObject 继承。)
公共事件 PropertyMetadataChanged (从 SqlSmoObject 继承。)

页首

字段

  名称 说明
受保护字段 m_ExtendedProperties (从 SqlSmoObject 继承。)

页首

显式接口实现

  名称 说明
显式接口实现私有方法 IAlienObjectDiscover (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObjectGetParent (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObjectGetProperty (从 SqlSmoObject 继承。)
显式接口实现私有方法 ISfcPropertyProviderGetPropertySet (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObjectGetUrn (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObjectResolve (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObjectSetProperty (从 SqlSmoObject 继承。)

页首

注释

To get or set Alert object properties, users must be a member of the sysadmin fixed server role.

To create or drop an Alert users must be a member of the sysadmin fixed server role.

Thread Safety

此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。 不保证所有实例成员都对于线程安全的。

线程安全

此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。