Maintain Data Table by Location

Delete data for a specific location by period or category.

Use Maintain Data Table by Location to delete data for a specific location by period or category.

Note:

To delete all locations for an application, use the Maintain Data Tables by Application option. This option enables you to delete data across all locations associated with a selected target application. For more information, see Maintain Data Table by Application.

Maintain Setup Data uses a Mode parameter, which enables you to either preview or delete invalid data.

The parameters are:

• Location

• Start Period

• End Period

• Category

Note:

If you need to delete multiple period mapping but you are unsure which integrations include period mappings, leave Location and Category blank if you want to delete all the period mappings.

To run the Maintain Data Table by Location task:

1. Click Application, then Jobs, and then Schedule Jobs.

2. From the Schedule Jobs page, then What type of job is this?, select Integration Maintenance Script.

3. To schedule an integration maintenance script to run now, see Scheduling Hourly Jobs .

   To schedule an integration maintenance script to run later, see Scheduling a Data Rule or Integration Definition to Run Later in the Job Scheduler.

4. Click Next.

5. From Integration Maintenance Script page, click to the right of the Maintain Data Table by Location task to schedule.

6. From the Maintain Data Table by Location page, and then from the Location drop-down, select the location from which to delete data.

   To delete data from all locations, leave the Location field blank.

7. From Start Period, select the starting period from which to delete data.

8. From End Period, select the ending period from which to delete data.

9. From Category, select the category data to delete.

   To delete all category data, leave this field blank.

10. Click OK.