TargetServerGroup 类
The TargetServerGroup object that represent a target server group defined for multi-server administration on SQL Server Agent.
继承层次结构
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.TargetServerGroup
命名空间: Microsoft.SqlServer.Management.Smo.Agent
程序集: Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)
语法
声明
Public NotInheritable Class TargetServerGroup _
Inherits AgentObjectBase _
Implements ICreatable, IDroppable, IRenamable
用法
Dim instance As TargetServerGroup
public sealed class TargetServerGroup : AgentObjectBase,
ICreatable, IDroppable, IRenamable
public ref class TargetServerGroup sealed : public AgentObjectBase,
ICreatable, IDroppable, IRenamable
[<SealedAttribute>]
type TargetServerGroup =
class
inherit AgentObjectBase
interface ICreatable
interface IDroppable
interface IRenamable
end
public final class TargetServerGroup extends AgentObjectBase implements ICreatable, IDroppable, IRenamable
TargetServerGroup 类型公开以下成员。
构造函数
名称 | 说明 | |
---|---|---|
TargetServerGroup() | Initializes a new instance of the TargetServerGroup class. | |
TargetServerGroup(JobServer, String) | Initializes a new instance of the TargetServerGroup class on the specified SQL Server Agent and with the specified name. |
页首
属性
名称 | 说明 | |
---|---|---|
ID | Gets the ID value that uniquely identifies the target server group. | |
Name | Gets or sets the name of the object. (从 NamedSmoObject 继承。) | |
Parent | Gets the JobServer object that is the parent of the TargetServerGroup 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 继承。) |
页首
方法
名称 | 说明 | |
---|---|---|
AddMemberServer | Assigns target server group membership to the specified target server. | |
Create | Creates a target server group on the instance of SQL Server as defined by the TargetServerGroup object. | |
Discover | Discovers a list of type Object. (从 SqlSmoObject 继承。) | |
Drop | Removes the referenced target server group. | |
EnumMemberServers | Enumerates a list of target servers that are members of the referenced target server group. | |
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 继承。) | |
RemoveMemberServer | Withdraws membership of the referenced target server group from the specified target server. | |
Rename | Renames the referenced target server group. | |
Script() | Generates a Transact-SQL script that can be used to re-create the target server group. | |
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the target server group as specified by the script 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 继承。) |
页首
注释
To get or set TargetServerGroup object properties, users must be a member of the sysadmin fixed server role.
To create or drop a target server group, users must be a member of the sysadmin fixed server role.
To add or remove members, users must be a member of the sysadmin fixed server role.
To run methods on the TargetServerGroup object, users must be a member of the sysadmin fixed server role.
Thread Safety
此类型的任何公共静态(Microsoft Visual Basic 中的 Shared)成员在多线程操作中是安全的。但不保证所有实例成员都是线程安全的。
示例
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。
请参阅
参考
Microsoft.SqlServer.Management.Smo.Agent 命名空间