Share via


Scheduling Reports and Subscriptions

You can schedule reports and subscriptions in Report Manager or SQL Server Management Studio to retrieve data and deliver reports at specific times or during off-peak hours. Schedules can run once or on a continuous basis at intervals of hours, days, weeks, or months. You can:

  • Schedule report delivery in a standard or data-driven subscription.
  • Schedule report history so that new snapshots are added to report history at regular intervals.
  • Schedule when to refresh the data of a report snapshot.
  • Schedule the expiration of a cached report to occur at a predefined time so that it can be subsequently refreshed.

You can create a shared schedule if you want to use the same schedule information for many reports or subscriptions. Shared schedules are defined separately, and then referenced in reports and subscriptions that need schedule information.

When you create a schedule, the report saves the schedule information in the report server database. The report server also creates a SQL Server Agent job that is used to trigger the schedule. Schedule processing is based on the local time of the report server that contains the schedule. The time format follows the Microsoft Windows operating system standard. For more information about the scheduling engine used in Reporting Services, see Scheduling and Delivery Processor.

Note

Scheduled operations are not supported in SQL Server 2005 Express Edition with Advanced Services. For more information about features in this edition, see Reporting Services in SQL Server 2005 Express Edition with Advanced Services.

In This Section

Topic Description

Creating, Modifying, and Deleting Schedules

Explains how to create, modify, and delete shared and report-specific schedules.

Pausing and Resuming Shared Schedules

Explains how to pause and resume schedules that are in process.

Changing Time Zones and Clock Settings on a Report Server

Provides information about the effects of time zone changes and clock settings on existing reports and schedules.

See Also

Concepts

Creating, Modifying, and Deleting Snapshots in Report History
Data-Driven Subscriptions
Report Caching in Reporting Services

Other Resources

Delivering Reports Through Subscriptions
Managing and Working With Published Reports

Help and Information

Getting SQL Server 2005 Assistance