Export (0) Print
Expand All

How to: Run Replication Maintenance Jobs (SQL Server Management Studio)

Replication uses the following maintenance jobs:

  • Reinitialize subscriptions having data validation failures
  • Agent history clean up: distribution
  • Replication monitoring refresher for distribution.
  • Replication agents checkup
  • Distribution clean up: distribution
  • Expired subscription clean up

Start and stop these jobs from the Jobs folder in Microsoft SQL Server Management Studio and from the Common Jobs tab in Replication Monitor. For information about starting Replication Monitor, see How to: Start Replication Monitor (Replication Monitor). View and modify properties for each job in the Job Properties - <Job> dialog box, which is available from the same folder and tab.

  1. Connect to the Distributor in Management Studio, and then expand the server node.

  2. Expand the SQL Server Agent folder, and then expand the Jobs folder.

  3. Right-click a job, and then click Start Job or Stop Job.

  1. Expand a Publisher group in Replication Monitor, and then select a Publisher.

  2. Click the Common Jobs tab.

  3. Right-click a job in the grid, and then click Start Job or Stop Job.

  1. Connect to the Distributor in Management Studio, and then expand the server node.

  2. Expand the SQL Server Agent folder, and then expand the Jobs folder.

  3. Right-click a job, and then click Properties.

  4. In the Job Properties - <Job> dialog box, modify any properties if necessary, and then click OK.

  1. Expand a Publisher group in Replication Monitor, and then select a Publisher.

  2. Click the Common Jobs tab.

  3. Right-click a job in the grid, and then click Properties.

  4. In the Job Properties - <Job> dialog box, modify any properties if necessary, and then click OK.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft