Share via


CreateAgentProfile Method

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

The CreateAgentProfile method creates a replication agent profile.

Sintaxis

object.CreateAgentProfile(bstrName,bstrDescription,ReplAgentType)asLong

Parts

  • object
    Expression that evaluates to an object in the Applies To list.

  • bstrName
    String that specifies profile name.

  • bstrDescription
    String that contains descriptive text.

  • ReplAgentType
    Long integer that specifies a replication agent type as described in Settings.

Prototype (C/C++)

HRESULT CreateAgentProfile(SQLDMO_LPCSTR szName,
SQLDMO_LPCSTR szDescription,
SQLDMO_REPLAGENT_TYPE AgentType, long *plProfileID);

Settings

Set the ReplAgentType argument using these SQLDMO_REPLAGENT_TYPE values.

Constant

Value

Description

SQLDMOReplAgent_Distribution

3

Replication Distribution Agent

SQLDMOReplAgent_LogReader

2

Replication transaction log monitoring agent

SQLDMOReplAgent_Merge

4

Replication Merge Agent

SQLDMOReplAgent_QueueReader

9

Replication Queue Reader Agent

SQLDMOReplAgent_Snapshot

1

Replication Snapshot Agent

Returns

A system-generated, long integer that identifies the agent profile.

Notas

Use the CreateAgentProfile method to add a replication agent profile to a Distributor. The new profile is a copy of the default profile in use for the agent.

Use the ChangeAgentParameter method to modify parameter values and change the behaviors configured by the newly created profile.

Applies to: