次の方法で共有


CreateAgentProfile Method

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

The CreateAgentProfile method creates a replication agent profile.

構文

object
.CreateAgentProfile(
bstrName
,
bstrDescription
,
ReplAgentType
)
as
Long

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:

Distributor Object