Approach to delete remp tables created by wkf:Uncheck interim result workflows, purge history and manually execute the cleanup workflow. We saw in the backend database that it deletes the data without manual intervention.

Question

@costa_n11 ,All
 
please recomemnd: 
We have close to 2000 OLD wkfs LAST PROCESSED ON 2019 where  "kEep interim result ..." is checked 
now coz of this lot of temp tables were created and right now also they exist in db
now wwe want those tables to deleted from db====
we are thinking to follow this approach as recommeded by one of our colleegue":
Could you please suggest if this approach is safe in this case:
 
1. Uncheck interim result workflows, purge history and manually execute the cleanup workflow. We saw in the backend database that it deletes the data without manual intervention.

ParthaSarathy · Accepted Answer

Hi @shruti1 ,Refer here for Workflow to uncheck keepInterim in all WorkflowsAs you have more number of workflows to uncheck keepInterim, You can create and modify the above workflow to uncheck all the WKFs automatically where keepInterim is enabled. Once unchecked, the temp table will get deleted in days mentioned in workflow property.

Shubham_Goyal__ · Answer

Hi @shruti1 ,

After executing the remedy steps suggested by @ParthaSarathy you can ask your DBA (if On-Prem hosted) or Adobe (if Adobe hosted) to perform DB Vacuum.
A DB Vacuum will help you reclaims storage occupied by the dead tuples from your DB.

Br,

Shubham

Sign up

Login with SSO

Login to the community

Login with SSO