AlertSystem 类

The AlertSystem class contains system information pertaining to all alerts defined on the instance of Microsoft SQL Server.

继承层次结构

System.Object
  Microsoft.SqlServer.Management.Smo.SmoObjectBase
    Microsoft.SqlServer.Management.Smo.SqlSmoObject
      Microsoft.SqlServer.Management.Smo.NamedSmoObject
        Microsoft.SqlServer.Management.Smo.Agent.AgentObjectBase
          Microsoft.SqlServer.Management.Smo.Agent.AlertSystem

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

语法

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

AlertSystem 类型公开以下成员。

属性

  名称 说明
公共属性 FailSafeEmailAddress Gets or sets an e-mail address to notify when no operator is defined or available on alert notification.
公共属性 FailSafeNetSendAddress Gets or sets a net send address to notify when no operator is defined or available on alert notification.
公共属性 FailSafeOperator Gets or sets the operator to notify when no other operator is defined or available on the alert notification.
公共属性 FailSafePagerAddress Gets or sets a pager address to notify when no operator is defined or available on alert notification.
公共属性 ForwardingServer Gets or sets the instance of Microsoft SQL Server that will receive forwarded events.
公共属性 ForwardingSeverity Gets or sets the minimum severity level of error event that is to be forwarded to another instance of SQL Server.
公共属性 IsForwardedAlways Gets or sets the Boolean property value that specifies whether all events are forwarded to the forwarding server or only those that have no event notification defined on the current instance of SQL Server.
公共属性 Name Gets or sets the name of the object. (从 NamedSmoObject 继承。)
公共属性 NotificationMethod Gets or sets the notification method used to notify the fail-safe operator.
公共属性 PagerCCTemplate Gets or sets the template text sent in the e-mail Cc: line in the e-mail sent by SQL Server Agent for pager notifications.
公共属性 PagerSendSubjectOnly Gets or sets the Boolean property value that specifies whether to include the e-mail Message: text in the e-mail sent by SQL Server Agent for pager notifications.
公共属性 PagerSubjectTemplate Gets or sets the template text sent in the e-mail Subject: line in the e-mail sent by SQL Server Agent for pager notifications.
公共属性 PagerToTemplate Gets or sets the template text sent in the e-mail To: line in the e-mail sent by SQL Server Agent for pager notifications.
公共属性 Parent Gets the JobServer object value that is the parent of the AlertSystem object.
公共属性 Properties Gets a collection of Property objects that represent the object properties. (从 SqlSmoObject 继承。)
公共属性 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 继承。)

页首

方法

  名称 说明
公共方法 Alter Updates any AlertSystem object property changes on an instance of SQL Server. 
公共方法 Discover Discovers a list of type Object. (从 SqlSmoObject 继承。)
公共方法 Equals (从 Object 继承。)
受保护方法 FormatSqlVariant Formats an object as SqlVariant type. (从 SqlSmoObject 继承。)
受保护方法 GetContextDB Gets the context database that is associated with this object. (从 SqlSmoObject 继承。)
受保护方法 GetDBName Gets the database name that is associated with the object. (从 AgentObjectBase 继承。)
公共方法 GetHashCode (从 Object 继承。)
受保护方法 GetPropValue Gets a property value of the SqlSmoObject object. (从 SqlSmoObject 继承。)
受保护方法 GetPropValueOptional Gets a property value of the SqlSmoObject object. (从 SqlSmoObject 继承。)
受保护方法 GetPropValueOptionalAllowNull Gets a property value of the SqlSmoObject object. (从 SqlSmoObject 继承。)
受保护方法 GetServerObject Gets the server of the SqlSmoObject object. (从 SqlSmoObject 继承。)
公共方法 GetType (从 Object 继承。)
公共方法 Initialize() Initializes the object and forces the properties be loaded. (从 SqlSmoObject 继承。)
公共方法 Initialize(Boolean) Initializes the object and forces the properties be loaded. (从 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 继承。)
公共方法 Refresh Refreshes the object and retrieves properties when the object is next accessed. (从 SqlSmoObject 继承。)
公共方法 Script() Generates a Transact-SQL script that can be used to re-create the set of information represented by the AlertSystem object.
公共方法 Script(ScriptingOptions) Generates a Transact-SQL script that can be used to re-create the set of information represented by the AlertSystem object and as specified by the scripting options.
受保护方法 SetParentImpl Sets the parent of the SqlSmoObject to the newParent parameter. (从 SqlSmoObject 继承。)
公共方法 ToString Returns a String that represents the referenced object. (从 SqlSmoObject 继承。)
公共方法 Validate Validates the state of an object. (从 SmoObjectBase 继承。)

页首

事件

  名称 说明
公共事件 PropertyChanged Represents the event that occurs when a property is changed. (从 SqlSmoObject 继承。)
公共事件 PropertyMetadataChanged Represents the event that occurs when property metadata changes. (从 SqlSmoObject 继承。)

页首

显式接口实现

  名称 说明
显式接口实现私有方法 IAlienObject.Discover Discovers any dependencies. 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObject.GetDomainRoot Returns the root of the domain. (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObject.GetParent Gets the parent of this object. 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObject.GetPropertyType Gets the type of the specified property. (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObject.GetPropertyValue Gets the value of the specified property. (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObject.GetUrn Gets the Unified Resource Name (URN) of the object. 不要在您的代码中直接引用此成员。它支持 SQL Server 基础结构。 (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObject.Resolve Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObject.SetObjectState Sets the object state to the specified SfcObjectState value. (从 SqlSmoObject 继承。)
显式接口实现私有方法 IAlienObject.SetPropertyValue Sets the property value. (从 SqlSmoObject 继承。)
显式接口实现私有方法 ISfcPropertyProvider.GetPropertySet Gets the interface reference to the set of properties of this object. (从 SqlSmoObject 继承。)

页首

注释

Thread Safety

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

示例

在 SQL Server 代理中计划自动管理任务

线程安全

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

请参阅

参考

Microsoft.SqlServer.Management.Smo.Agent 命名空间

其他资源

自动执行管理任务(SQL Server 代理)

sp_add_alert (Transact-SQL)