Pausing and Resuming 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 cannot pause report-specific schedules.

How to Pause and Resume Schedules

To pause and resume a shared schedule, use the Shared 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 Shared Schedules Page (Report Manager).

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. However, you can monitor and delete jobs that are running. For more information, see Managing a Running Process.

While a shared schedule is paused, all report processing associated with the schedule is deferred until the schedule is resumed.

After you resume a shared schedule, report processing occurs at the next scheduled time, using the local time of the report server. Any reports are skipped that did not run because a shared schedule was paused. This principle applies to both time-based and event-driven schedules. The schedule initiates report processing when the next event (for example, a scheduled update to a report cache) is detected.

See Also


How to: Create, Delete, or Modify a Shared Schedule (Management Studio)
How to: Create, Delete, or Modify a Shared Schedule (Report Manager)


Scheduling and Delivery Processor
Creating, Modifying, and Deleting Schedules

Other Resources

Scheduling Reports and Subscriptions

Help and Information

Getting SQL Server 2005 Assistance