Data Aging Tasks

Quest Reporter will switch to the Simple mode of transaction logging (see Set Database Recovery Model.) during this task to avoid the creation of excessively large log files. When the task is complete, Reporter will return the transaction logging to its previous value.

To begin a new data aging task

1.	Follow the instructions above (see Creating New Tasks.) and select Data Aging Task.

2.	Select the tables that will be cleaned.

Each table may be expanded to expose both the related data table and the transaction log table. Either or both of these tables may be selected. The default is to select both subsidiary tables.

3.	Select one of the two data aging criteria.

The options available include:

•	Older than: all information in the selected table older than the specified time will be deleted.

•	Before: all information in the selected table that was created before the specified date will be deleted.

4.	Click Next.

5.	Enter the user name and password that will be used to access the database, including the domain in the form domain\username if necessary, and click Next.

6.	Select the time and frequency that the task will be performed.

Either choose among the provided options or click Advanced for more detailed options.

7.	If you want an email to be sent when the task is complete, check the box labelled Send an email message when the task finishes and provide the required information in the text boxes provided.

8.	Click Next.

9.	Review the summary information and click Finish.

The task will be added to the list of tasks in the upper pane of the Maintenance tab.

Due to the number of operations performed during this task, Quest recommends a truncation of the transaction log file after the task is complete. For more information, see Truncate the Transaction Log.

Using the Configuration tool, it is possible to extend attributes collected by Reporter. If an extended attribute supports multiple values, the resulting database table which stores those values can not be cleaned by the Data Aging task.