.png)
TargetServer Class
SQL Server 2012
The TargetServer object represents a target server defined for multiserver 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.TargetServer
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.TargetServer
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
The TargetServer type exposes the following members.
| Name | Description | |
|---|---|---|
 | EnlistDate | Gets the date and time at which an instance of Microsoft SQL Server was enlisted as a member of a multiserver administration group. |
| ID | Gets the ID value for the instance of Microsoft SQL Server that is the target server. |
| LastPollDate | Gets the most recent date and time at which the referenced target server successfully connected to its master server. |
| LocalTime | Gets the current date and time for the referenced target server. |
| Location | Gets or sets the physical location of the referenced target server. |
| Name | Gets or sets the name of the object. (Inherited from NamedSmoObject.) |
| Parent | Gets the JobServer object that is the parent of the TargetServer object. |
| PendingInstructions | Gets the number of SQL Server Agent maintenance tasks waiting to be downloaded by the target server from the master server. |
| PollingInterval | Gets the length of time in seconds that the target server waits between attempts to connect to the master server to download pending instructions. |
| Properties | Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.) |
| State | Gets the state of the referenced object. (Inherited from SmoObjectBase.) |
| Status | Gets information about the current component execution status or integrity status of the referenced target server. |
| TimeZoneAdjustment | Gets the difference, in minutes, between the local time midnight on the target server and midnight Coordinated Universal Time (Greenwich Mean Time). |
| Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.) |
| UserData | Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.) |
| Name | Description | |
|---|---|---|
| Discover | Discovers a list of type Object. (Inherited from SqlSmoObject.) |
| Equals | (Inherited from Object.) |
| FormatSqlVariant | Formats an object as SqlVariant type. (Inherited from SqlSmoObject.) |
| GetContextDB | Gets the context database that is associated with this object. (Inherited from SqlSmoObject.) |
| GetDBName | Gets the database name that is associated with the object. (Inherited from AgentObjectBase.) |
| GetHashCode | (Inherited from Object.) |
| GetPropValue | Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetPropValueOptional | Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetServerObject | Gets the server of the SqlSmoObject object. (Inherited from SqlSmoObject.) |
| GetType | (Inherited from Object.) |
| Initialize() | Initializes the object and forces the properties be loaded. (Inherited from SqlSmoObject.) |
| Initialize(Boolean) | Initializes the object and forces the properties be loaded. (Inherited from SqlSmoObject.) |
| IsObjectInitialized | Verifies whether the object has been initialized. (Inherited from SqlSmoObject.) |
| IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (Inherited from SqlSmoObject.) |
| Refresh | Refreshes the object and retrieves properties when the object is next accessed. (Inherited from SqlSmoObject.) |
| SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (Inherited from SqlSmoObject.) |
| ToString | Returns a String that represents the referenced object. (Inherited from SqlSmoObject.) |
| Validate | Validates the state of an object. (Inherited from SmoObjectBase.) |
| Name | Description | |
|---|---|---|
| PropertyChanged | Represents the event that occurs when a property is changed. (Inherited from SqlSmoObject.) |
| PropertyMetadataChanged | Represents the event that occurs when property metadata changes. (Inherited from SqlSmoObject.) |
| Name | Description | |
|---|---|---|
| IAlienObject.Discover | Discovers any dependencies. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.) |
| IAlienObject.GetDomainRoot | Returns the root of the domain. (Inherited from SqlSmoObject.) |
| IAlienObject.GetParent | Gets the parent of this object. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.) |
| IAlienObject.GetPropertyType | Gets the type of the specified property. (Inherited from SqlSmoObject.) |
| IAlienObject.GetPropertyValue | Gets the value of the specified property. (Inherited from SqlSmoObject.) |
| IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. Do not reference this member directly in your code. It supports the SQL Server infrastructure. (Inherited from SqlSmoObject.) |
| IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (Inherited from SqlSmoObject.) |
| IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. (Inherited from SqlSmoObject.) |
| IAlienObject.SetPropertyValue | Sets the property value. (Inherited from SqlSmoObject.) |
| ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. (Inherited from SqlSmoObject.) |
