Skip to content

Latest commit

 

History

History
74 lines (47 loc) · 3.49 KB

run-replication-maintenance-jobs-sql-server-management-studio.md

File metadata and controls

74 lines (47 loc) · 3.49 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom helpviewer_keywords monikerRange
Run replication maintenance jobs (SSMS)
Learn how to start and stop replication maintenance jobs in SQL Server management Studio (SSMS).
MashaMSFT
mathoma
09/25/2024
sql
replication
how-to
updatefrequency5
jobs [SQL Server replication]
=azuresqldb-mi-current||>=sql-server-2016

Run Replication Maintenance Jobs (SQL Server Management Studio)

[!INCLUDEsql-asdbmi] 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 [!INCLUDEmsCoName] [!INCLUDEssManStudioFull] 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 [!INCLUDEssManStudio], 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 [!INCLUDEssManStudio], 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.

Related content