How do I schedule snapshots in Reporting Services? So that it automatically creates snapshots based on a schedule in Reporting Services.

Its easy.

  1. Open the Report in Report Manager (usually http://localhost/reports)

    Figure: Open the report to schedule in Report Manager

  2. Click Properties
  3. Click Execution
  4. Click Render this report from a report execution snapshot
  5. Tick Use the following schedule to create report execution snapshots:
  6. Click Configure

    Figure: Set the execution properties of the reportr

  7. Select the scheduling options you want then click OK
  8. Click OK on the Execution Properties page and Apply to save the changes and start creating the snapshot

    The report will now execute from a snapshot and a the snapshot will be updated according to the schedule specified.

    Spot an error? Please comment about this article

    Keywords: Hot Tip - Reporting Services    

    New Search SSW Custom Support