Skip to content

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

Latest commit

 

History

History
77 lines (49 loc) · 3.72 KB

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

File metadata and controls

77 lines (49 loc) · 3.72 KB
title Run replication maintenance jobs (SSMS)
description Learn how to start and stop replication maintenance jobs in SQL Server management Studio (SSMS).
ms.custom seo-lt-2019
ms.date 03/14/2017
ms.prod sql
ms.prod_service database-engine
ms.reviewer
ms.technology replication
ms.topic conceptual
helpviewer_keywords
jobs [SQL Server replication]
ms.assetid 0dc485a0-5a50-41eb-a29d-f2b2fb920174
author MashaMSFT
ms.author mathoma
monikerRange =azuresqldb-mi-current||>=sql-server-2016||=sqlallproducts-allversions

Run Replication Maintenance Jobs (SQL Server Management Studio)

[!INCLUDEappliesto-ss-asdbmi-xxxx-xxx-md] 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.

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