How to Automate The DLR Issues Purge Process Within TBS Utility (Doc ID 2252717.1)

Last updated on FEBRUARY 21, 2022

Applies to:

Goal

QUESTION

How can we automate the DLR Issues purges within the TBS Utility?

We have not been able to trace the purging of DLR Issues within the TBS Utility, using the SQL Spy facility.

Customer is looking to automate the DLR Issue purges rather then having a person required to login to the TBS Utility and perform these functions daily, weekly, monthly etc.

Customer would like to either create a script and execute it nightly to purge the DLR Issues or get a job manager setup to perform this function.
We would like to test both and determine which is most efficient but unfortunately I have not been able to locate the sql or which related tables are impacted with the DLR purge to automate.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.