View and Modify Replication Agent Command Prompt Parameters
Applies to: SQL Server
Replication agents are executables that accept command line parameters. By default, agents run under Microsoft SQL Server Agent job steps, so these parameters can be viewed and modified using the Job Properties - <Job> dialog box. This dialog box is available from the Jobs folder in SQL Server Management Studio and from the Agents tab in Replication Monitor. For information about starting Replication Monitor, see Start the Replication Monitor.
Note
Agent parameter changes take effect the next time the agent is started. If the agent runs continuously, you must stop and restart the agent.
Although parameters can be modified directly, it is more common to modify them through an agent profile. For more information, see Replication Agent Profiles.
If you access agent jobs from the Jobs folder, use the following table to determine the agent job name and the parameters available for each agent.
Agent | Job name | For a list of parameters, see… |
---|---|---|
Snapshot Agent | <Publisher>-<PublicationDatabase>-<Publication>-<integer> | Replication Snapshot Agent |
Snapshot Agent for a merge publication partition | Dyn_<Publisher>-<PublicationDatabase>-<Publication>-<GUID> | Replication Snapshot Agent |
Log Reader Agent | <Publisher>-<PublicationDatabase>-<integer> | Replication Log Reader Agent |
Merge Agent for pull subscriptions | <Publisher>-<PublicationDatabase>-<Publication>-<Subscriber>-<SubscriptionDatabase>-<integer> | Replication Merge Agent |
Merge Agent for push subscriptions | <Publisher>-<PublicationDatabase>-<Publication>-<Subscriber>-<integer> | Replication Merge Agent |
Distribution Agent for push subscriptions | <Publisher>-<PublicationDatabase>-<Publication>-<Subscriber>-<integer> | Replication Distribution Agent |
Distribution Agent for pull subscriptions | <Publisher>-<PublicationDatabase>-<Publication>-<Subscriber>-<SubscriptionDatabase>-<GUID> | Replication Distribution Agent |
Distribution Agent for push subscriptions to non-SQL Server Subscribers | <Publisher>-<PublicationDatabase>-<Publication>-<Subscriber>-<integer> | Replication Distribution Agent |
Queue Reader Agent | [<Distributor>].<integer> | Replication Queue Reader Agent |
*For push subscriptions to Oracle publications, it is <Publisher>-<Publisher> rather than <Publisher>-<PublicationDatabase>
**For pull subscriptions to Oracle publications, it is <Publisher>-<DistributionDatabase> rather than <Publisher>-<PublicationDatabase>
To view and modify replication agent command line parameters from Management Studio
Connect to the appropriate computer in Management Studio, and then expand the server node:
For the Distribution Agent and Merge Agent for pull subscriptions, connect to the Subscriber.
For all other agents, connect to the Distributor.
Expand the SQL Server Agent folder, and then expand the Jobs folder.
Right-click a job, and then click Properties.
On the Steps page of the Job Properties - <Job> dialog box, select the step Run agent, and then click Edit.
In the Job Step Properties - Run agent dialog box, edit the Command field.
Click OK on both dialog boxes.
To view and modify Distribution Agent and Merge Agent command line parameters from Replication Monitor
Expand a Publisher group in the left pane of Replication Monitor, expand a Publisher, and then click a publication.
Click the All Subscriptions tab.
Right-click a subscription, and then click View Details.
In the Subscription < SubscriptionName> window, click Action, and then click <AgentName> Job Properties.
On the Steps page of the Job Properties - <Job> dialog box, select the step Run agent, and then click Edit.
In the Job Step Properties - Run agent dialog box, edit the Command field.
Click OK on both dialog boxes.
To view and modify Snapshot Agent, Log Reader Agent, and Queue Reader Agent command line parameters from Replication Monitor
Expand a Publisher group in the left pane of Replication Monitor, expand a Publisher, and then click a publication.
Click the Agents tab.
Right-click an agent in the grid, and then click Properties.
On the Steps page of the Job Properties - <Job> dialog box, select the step Run agent, and then click Edit.
In the Job Step Properties - Run agent dialog box, edit the Command field.
Click OK on both dialog boxes.