About Purging Batch Assignment Information

When a batch assignment job runs, it creates data as part of the assignment process. Once the job completes, the data is no longer required and can be purged.

The scheduled process Purge Batch Assignment Information is used to purge the batch assignment tables based on set parameters. A batch assignment process creates data in two tables: MOW_BATCH_ASGN_JOBS and MOW_BATCH_ASGN_JOB_ITEMS. With time, records in these tables grow substantially, especially with large implementations. The purge batch assignment information process clears old records for successfully completed processes. The process purges data for batch assignment processes for leads, opportunities, accounts, and so on.

Run this process periodically or as needed. The process has only one parameter Days to Keep. The default value is 30.

Specify the number of days worth of assignment batch job and data to keep until the next purge. For example, if you set the parameter to 15, the process removes all rows related to successfully completed processes in the batch assignment data table that were created before 15 days from the current date.