Note: This setting is not applicable when you use the parquet format to archive the data.
You can create the delete script and not have it run after the archive. You can schedule the script by using crontab or other tools. This conserves resources during high-volume times. The pruning scripts is in in the following directory on the archive database client.
<job results location>CV_JobResults/2/0/<jobid>/srcDeleteScript.sql
Procedure
-
On the client computer, add the SkipPruneRowsOnSource additional setting as shown in the following table.
For instructions on adding additional settings from the CommCell Console, see Add or Modify an Additional Setting.
Property
Value
Name
Category
OracleAgent
Type
String
Value
dY