AgentProfile Members
Encapsulates all operations on replication agent profiles, such as creating, deleting, adding, and removing parameters, and assigning specific profiles to certain agents.
The following tables list the members exposed by the AgentProfile type.
Public Constructors
Name | Description | |
---|---|---|
AgentProfile | Overloaded. Initializes a new instance of the AgentProfile class. |
Top
Public Properties
Name | Description | |
---|---|---|
AgentType | Gets or sets the type of replication agent for which the profile is intended. | |
CachePropertyChanges | Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (inherited from ReplicationObject) | |
ConnectionContext | Gets or sets the connection to an instance of Microsoft SQL Server. (inherited from ReplicationObject) | |
Default | Specifies whether this profile is the default profile for the given replication agent type. | |
Description | Gets or sets a textual description of the replication agent profile. | |
IsExistingObject | Gets whether the object exists on the server or not. (inherited from ReplicationObject) | |
Name | Gets or sets the name of the replication agent profile. | |
ProfileId | ||
SqlServerName | Gets the name of the Microsoft SQL Server instance to which this object is connected. (inherited from ReplicationObject) | |
Type | Specifies whether the replication agent profile is pre-defined by replication or created by a user. | |
UserData | Gets or sets an object property that allows users to attach their own data to the object. (inherited from ReplicationObject) |
Top
Public Methods
(see also Protected Methods )
Name | Description | |
---|---|---|
AddParameter | Adds a parameter to the replication agent profile. | |
AssignToAgent | Assigns the replication agent profile to a specific replication agent job. | |
ChangeParameter | Changes the value of an existing replication agent parameter in the profile. | |
CommitPropertyChanges | Sends all the cached property change statements to the instance of Microsoft SQL Server. (inherited from ReplicationObject) | |
Create | Creates the replication agent profile on the instance of SQL Server by using the current properties. | |
Decouple | Decouples the referenced replication object from the server. (inherited from ReplicationObject) | |
EnumParameterInfo | Returns information about parameters that can be set and that are available for the replication agent profile. | |
EnumParameters | Returns all existing parameters that are set for the replication agent profile. | |
Equals | Overloaded. (inherited from Object ) | |
GetHashCode | (inherited from Object ) | |
GetType | (inherited from Object ) | |
Load | Loads the properties of an existing object from the server. (inherited from ReplicationObject) | |
LoadProperties | Loads the properties of an existing object from the server. (inherited from ReplicationObject) | |
MakeDefault | Sets the profile as the default profile for all replication agents of the same type. | |
ReferenceEquals | (inherited from Object ) | |
Refresh | Reloads the properties of the object. (inherited from ReplicationObject) | |
Remove | Removes an existing replication agent profile from the Distributor. | |
RemoveParameter | Removes an existing parameter from the replication agent profile. | |
Script | Generates a Transact-SQL script that can be used to re-create the agent profile. | |
ToString | (inherited from Object ) |
Top
Protected Methods
Name | Description | |
---|---|---|
CheckValidCreation | (inherited from ReplicationObject ) | |
CheckValidDefinition | (inherited from ReplicationObject ) | |
Finalize | (inherited from Object ) | |
GetChangeCommand | (inherited from ReplicationObject ) | |
GetCreateCommand | (inherited from ReplicationObject ) | |
GetDropCommand | (inherited from ReplicationObject ) | |
InternalRefresh | (inherited from ReplicationObject ) | |
MemberwiseClone | (inherited from Object ) |
Top
See Also
Reference
AgentProfile Class
Microsoft.SqlServer.Replication Namespace
Other Resources
How to: Work with Replication Agent Profiles (RMO Programming)