Muokkaa

Jaa


Run Replication Maintenance Jobs (SQL Server Management Studio)

Applies to: SQL Server Azure SQL Managed Instance

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 Agents tab in Replication Monitor. For information about starting Replication Monitor, see Start the 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 Agents 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 Agents 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.