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)成员在多线程操作中是安全的。但不保证所有实例成员都是线程安全的。
示例
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。
请参阅
参考
Microsoft.SqlServer.Management.Smo.Agent 命名空间