> ### Creating compaction job instances

> The DataCompaction job compacts and purges data in the FathomTrendDatabase. The primary purpose of this job is to help you to manage the size of the FathomTrendDatabase.

> Access the DataCompaction job from the Create Custom Job page, as shown in Figure 2–1.

> Figure 2–1: Create Custom Job page

> You must complete the necessary fields on the Data Compaction Job page, shown in Figure 2–2, to set up and run a database compaction job instance.

> Figure 2–2: Data Compaction Job page

> To set up and run a data compaction job:

> 1. Provide values for the Name and Description fields. The Name field is required.
> 2. In the Compact trend data more than days old field, identify the number of days for which you intend to compact data. A day, as defined for this field, begins at midnight. This is a required field.
> Note: You can compact only data more than a week old. If you enter a value of 1-6, no data compaction will take place.

> In the Purge archived data more than days old field, specify the number of days worth of data you want purged from the database.

> 3. Enter a value in the Working directory field. Note that the Working directory field identifies the command's current working directory. The directory you specify must exist. This property defaults to the working directory defined at installation.
> 4. Enter values in the Output file (stdout) and Output file (stderr) fields. The stdout location indicates where messages will be retained and the stderr location indicates where error messages will be retained. To append subsequent messages to these files, select the Append option.
> 5. Select the Debug log file option to obtain diagnostic details that help you debug job properties when setting up a job.
> For example, you can set this option and use the Run Now feature on the Job Summary page. Once you have submitted the job, Fathom makes debug trace file data available through the debug trace file link in the Job History section of the Job Summary page.

> 6. Select the Action option to indicate if the job can be used as an action. See the Resource Monitoring Guide for more information about actions.
> If you intend to set up actions and alerts for this job, click the Edit button associated with the Completion Actions and Alerts field. The Job Completion Actions and Alerts page appears:

> 7. Define any actions or alerts, then click Save to return to the Data Compaction Job page. See the Resource Monitoring Guide for more information about associating actions with alerts.
> 8. Click Save on the Data Compaction Job page. The Summary page appears:

> Once you create a Data Compaction job instance, you can view and edit the job's advanced information.

Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095