You can schedule a linked report to run on a regular basis to ensure that the information is up to date. To do this, use SQL Server Reporting Services Report Manager (SSRS). In SSRS Report Manager, you can schedule reports to run one time or on a continuous basis at intervals of hours, days, weeks, or months. You can do the following:

To configure a schedule for a report, follow the procedure in the Scheduling Reports and Subscriptions topic in SQL Server 2008 Books Online (