Pause and Resume Shared Schedules
Applies To: SQL Server 2016
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 cannot pause report-specific schedules.
You cannot 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, any operations that would have occurred 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, do not make up scheduled operations that would have occurred had the schedule not been paused.
In this Topic:
To pause and resume a shared schedule, use the Schedules page in Report Manager. You cannot use SQL Server Management Studio; it does not provide options for pausing and resuming schedules. For more information, see Create, Modify, and Delete Schedules.
From Report Manager Click, Site Settings.
Select the schedule, and click Pause or Resume in the ribbon. If a Schedule is currently paused, the Status column will contain Paused.
To pause and resume a shared schedule, use the Site Settings page or PowerShell. Schedules are managed per SharePoint site.
Click Site Actions.
Click Site Settings.
In the Reporting Services section, click Manage Shared Schedules.
Select the schedule, and click Pause Selected Schedules or Run Selected Schedules. If a Schedule is currently paused, the Status column will contain Paused.