Export (0) Print
Expand All
Expand Minimize

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

SQL Server 2005

  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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft