How to: Schedule the Expiration of a Cached Report (Management Studio)

To schedule the expiration of a cached report

  1. In Object Explorer, expand a report server node.

  2. Expand the Home folder, and navigate to the folder containing the report you want to schedule cache expiration for.

  3. Click Execution in the Select a page area.

  4. Click Always run this report with the most recent data.

  5. Select one of the following two cache options and configure the expiration as follows:

    • To make the cached copy expire after a particular time period, click Cache a temporary copy of the report. Expire copy of report after a number of minutes. Type the number of minutes for report expiration.
    • To make the cached copy expire on a schedule, click Cache a temporary copy of the report. Expire copy of report on the following schedule. Click Configure, or select a shared schedule to set a schedule for report expiration.
  6. Click OK.

See Also

Concepts

Creating, Modifying, and Deleting Schedules
Shared Schedules and Report-Specific Schedules
Pausing and Resuming Shared Schedules
Report Server How-to Topics

Other Resources

Scheduling Reports and Subscriptions

Help and Information

Getting SQL Server 2005 Assistance