Scheduling Automatic Purging of Report Data

You can reduce the amount of data in the system by deleting data collected up to and including a specified date. This operation is called purging. In addition to improving performance, purging old report data reduces the time needed to back up and restore Report Server data.

A purge cannot be undone. If you think you might want to restore this data at a later time, take one of the following actions before purging:

• Create a backup file. See Backing Up Data Manually for more information.

• Create an archive. See Creating an Archive Manually for more information.

To schedule the purging of report data:

1. Click Task Scheduler in the navigation bar.

2. Select the Purge task, and then click the Edit Task button.

   The Edit Task dialog box appears.

3. On the Task Information tab, make sure the Enabled check box is checked.

   When this check box is checked, the task runs according to the specified schedule. Otherwise, the task is disabled.

4. Click the Schedule tab.

5. Select Schedule Frequency, Start Date, and End Date options. You can leave the End Date field blank if you don't want the purge schedule to expire.

   By default, the schedule frequency for Purge is every month.

6. In the Time of day to run the task field, select the time to begin the backup task. The first list specifies an hour from 1 to 12, inclusive. The second list specifies minutes in 15 minute intervals (0, 15, 30, or 45). The third list specifies a.m. or p.m.

   The default time for the Purge task is 12 a.m.

7. By default, the Purge task purges all data except for the last day. If you want to change that setting, follow these steps:

   1. Click the Executables tab.

   2. Select the Purge Task executable, and then click the Edit button.

      The Edit Executable dialog box appears.

   3. Click the Parameters tab.

   4. Click the PurgeDate parameter, and click the Edit button.

      The Edit Executable dialog box appears.

   5. In the Value field, specify the last number of days, weeks, or months that you do not want purged.

   6. Click Save to save the new value and close the Edit Executable dialog box.

   7. Click Save to save settings and close the Edit Executable dialog box.

8. Click Save to save settings and close the Edit Task dialog box.