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. | Community
Skip to main content
S
Shruti1
New Participant
October 10, 2022
Solved

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.

  • October 10, 2022
  • 2 replies
  • 871 views

@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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

Hi @shruti1 ,

Refer here for Workflow to uncheck keepInterim in all Workflows

As 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.

 

2 replies

Shubham_Goyal__
Shubham_Goyal__
New Participant
October 11, 2022

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

    ParthaSarathy
    ParthaSarathyAccepted solution
    New Participant
    October 10, 2022

    Hi @shruti1 ,

    Refer here for Workflow to uncheck keepInterim in all Workflows

    As 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.

     

     ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
      Terms & ConditionsAccessibility statement

      Loading footer...