Start and stop agents from the Jobs folder and the Replication folder in Microsoft SQL Server Management Studio and from Replication Monitor. Start and stop the following agents and jobs:
-
The Snapshot Agent, which is used by all publications.
-
The Log Reader Agent, which is used by all transactional publications.
-
The Queue Reader Agent, which is used by transactional publications enabled for queued updating subscriptions.
-
The Distribution Agent, which synchronizes subscriptions to transactional and snapshot publications.
-
The Merge Agent, which synchronizes subscriptions to merge publications.
-
Replication maintenance jobs.
For more information about starting the Merge Agent and the Distribution Agent, see How to: Synchronize a Push Subscription (SQL Server Management Studio) and How to: Synchronize a Pull Subscription (SQL Server Management Studio). For more information about maintenance jobs, see How to: Run Replication Maintenance Jobs (SQL Server Management Studio).
For information about starting Replication Monitor, see How to: Start Replication Monitor (Replication Monitor).
To start and stop a Snapshot Agent or Log Reader Agent from Management Studio
-
Connect to the Publisher in Management Studio, and then expand the server node and the Replication folder.
-
Expand the Local Publications folder, and then right-click a publication.
-
Click View Snapshot Agent Status or View Log Reader Agent Status.
-
Click Start or Stop.
To start and stop a Queue Reader Agent from Management Studio
-
Connect to the Distributor in Management Studio, and then expand the server node.
-
Expand the SQL Server Agent folder, and then expand the Jobs folder.
-
Right-click the job for the agent, and then click Start Job or Stop Job. The name of the job for the Queue Reader Agent is in the form [<Distributor>].<integer>.
To start and stop a Snapshot Agent, Log Reader Agent, or Queue Reader Agent from Replication Monitor
-
Expand a Publisher group in the left pane, expand a Publisher, and then click a publication.
-
Click the Agents tab.
-
Right-click an agent, and then click Start Agent or Stop Agent.
See Also