Skip to content

Latest commit

 

History

History
61 lines (43 loc) · 3.63 KB

File metadata and controls

61 lines (43 loc) · 3.63 KB
title Pause and resume shared schedules
description In this article, learn how to pause and resume a shared schedule that's in use but not in progress. You can pause and resume in native mode or SharePoint mode.
ms.date 09/25/2024
ms.service reporting-services
ms.subservice subscriptions
ms.topic concept-article
ms.custom
updatefrequency5
helpviewer_keywords
pausing schedules
report-specific schedules [Reporting Services]
shared schedules [Reporting Services], resuming
resuming schedules
continuing schedules
schedules [Reporting Services], resuming
schedules [Reporting Services], pausing

Pause and resume shared schedules

You can pause and resume a shared schedule that is in use. Pausing a shared schedule provides a way to temporarily freeze a schedule that is used to trigger report processing and subscriptions. Only shared schedules can be paused and resumed. You can't pause report-specific schedules.

You can't pause and resume report processing that is in progress. You can only pause and resume schedules that are in the scheduling queue of SQL Server Agent service. A job that is in progress is outside the scope of the scheduling engine. For more information, see Manage a running process

While a shared schedule is paused, operations are allowed to lapse. After you resume a shared schedule, report and subscription processing occurs at the next scheduled time, using the local time of the server. The native mode report server or SharePoint service applications don't make up scheduled operations that were paused.

In this article:

Pause and resume shared schedules (native mode)

To pause and resume a shared schedule, use the Schedules page in Report Manager. You can't use [!INCLUDEssNoVersion] [!INCLUDEssManStudio]; it doesn't provide options for pausing and resuming schedules. For more information, see Create, modify, and delete schedules.

Pause or resume a shared schedule

  1. From Report Manager select, Site Settings.

  2. Select Schedules.

  3. Choose the schedule, and select Pause or Resume in the ribbon. If a Schedule is currently paused, the Status column contains Paused.

Pause and resume shared schedules (SharePoint mode)

To pause and resume a shared schedule, use the Site Settings page or PowerShell. Schedules are managed per SharePoint site.

Pause or resume a shared schedule

  1. Select Site Actions.

  2. Select Site Settings.

  3. In the Reporting Services section, select Manage Shared Schedules.

  4. Choose the schedule, and select Pause Selected Schedules or Run Selected Schedules. If a Schedule is currently paused, the Status column contains Paused.

Related content