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
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 a job, and then click Start Job or Stop Job.
To start or stop a replication maintenance job in Replication Monitor
Expand a Publisher group in Replication Monitor, and then select a Publisher.
Click the Agents tab.
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
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 a job, and then click Properties.
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
Expand a Publisher group in Replication Monitor, and then select a Publisher.
Click the Agents tab.
Right-click a job in the grid, and then click Properties.
In the Job Properties - <Job> dialog box, modify any properties if necessary, and then click OK.
See Also
Start and Stop a Replication Agent (SQL Server Management Studio)
View Information and Perform Tasks for a Publisher (Replication Monitor)
Replication Agent Administration