共用方式為


CreateAgentProfile Method

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。

The CreateAgentProfile method creates a replication agent profile.

語法

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.

備註

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: