mitch.fh (2/14/2013)

---

Hi anthony,

This just seems to be the description of the user interface and how you can create/edit/delete cache-plans.

I didn't find anything here that tells you how to do it with SQL

cheers,

mitch

To open the Cache Refresh Plan properties page for a report or shared dataset

Open Report Manager, and locate the report or shared dataset for which you want to configure cache refresh plan properties.

Hover over the report or shared dataset, and click the drop-down arrow.

In the drop-down list, click Manage. The General properties page opens.

Click the Cache Refresh Plan tab.

To create a new cache plan, click New Cache Refresh Plan.

NoteNote

You must enable and start the SQL Server Agent service to create a cache refresh plan.

To create a copy of a cache plan and then customize it, click New from Existing.