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

To schedule the expiration of a cached report

  1. In Report Manager, navigate to the Contents page. Navigate to the report for which you want to reschedule a snapshot execution, and click the report to open it.

  2. Click the Properties tab.

  3. In the left frame, click the Execution tab.

  4. On the page, select Render this report with the most recent data.

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

    • To configure a cached copy to 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 configure a cached copy to 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 control report expiration
  6. Click Apply.

See Also

Concepts

Creating, Modifying, and Deleting Schedules
Shared Schedules and Report-Specific Schedules
Pausing and Resuming Shared Schedules

Other Resources

Contents Page (Report Manager)
Scheduling Reports and Subscriptions
New Schedule / Edit Schedule Page (Report Manager)

Help and Information

Getting SQL Server 2005 Assistance