How to: Schedule the Expiration of a Cached Report (Report Manager)
SQL Server 2005
-
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.
-
Click the Properties tab.
-
In the left frame, click the Execution tab.
-
On the page, select Render this report with the most recent data.
-
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
-
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.
-
Click Apply.
Concepts
Creating, Modifying, and Deleting SchedulesShared 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)