Edit

Pause and resume shared schedules

  • Article

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 SQL Server Management Studio; 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

Schedules
Create, modify, and delete schedules
Change time zones and clock settings on a report server
Manage a running process