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

  • Article

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.

To start or stop a replication maintenance job in Management Studio

  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.

To start or stop a replication maintenance job in Replication Monitor

  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.

To view and modify properties for a replication maintenance job in Management Studio

  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.

To view and modify properties for a replication maintenance job in Replication Monitor

  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.

See Also

Tasks

How to: Start and Stop a Replication Agent (SQL Server Management Studio)
How to: View Information and Perform Tasks for a Publisher (Replication Monitor)

Concepts

Administering Replication Agents

Help and Information

Getting SQL Server 2005 Assistance