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

Last updated on APRIL 10, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms