Workflow properties :History in 30 days menaing? | Community
Skip to main content
Level 4
September 16, 2023
Solved

Workflow properties :History in 30 days menaing?

  • September 16, 2023
  • 3 replies
  • 1104 views

Workflow properties :History in 30 days menaing?

 

Also we have keep interim checked for aroung 100 workflows and those wkfs we have run one time only........

so all the temp tables that are craeted during executions of these wkfs will be there for forever IN ? or when they will be deleted?

 

 

 

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 ,

Workflow audit logs and if any temporary table got created for the particular workflow, these will be get deleted when 'History in days' reached.

If you have given history in days as 30, so after 30 days the temporary table will be purged.

As you mentioned there are 100 workflows with keep the interim result enabled, this will cause negative impact in database storage. It is advised that, only during development or testing of a workflow you need to enable 'keep the interim result' option and once testing or development is done, then you need to uncheck it and restart the workflow.

 

For more details...

 

ParthaSarathy S

3 replies

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
September 16, 2023

Hi @shruti1 ,

Workflow audit logs and if any temporary table got created for the particular workflow, these will be get deleted when 'History in days' reached.

If you have given history in days as 30, so after 30 days the temporary table will be purged.

As you mentioned there are 100 workflows with keep the interim result enabled, this will cause negative impact in database storage. It is advised that, only during development or testing of a workflow you need to enable 'keep the interim result' option and once testing or development is done, then you need to uncheck it and restart the workflow.

 

For more details...

 

ParthaSarathy S

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
Level 4
September 18, 2023

thanks

Marcel_Szimonisz
Community Advisor
Community Advisor
September 18, 2023

Hello @shruti1,

the "history in days" setting could be only for SQL logs, posibly for data kept in the workflow temporary tables. I could not find it in the documentation.

But for sure at least workflow  audit log, is set on deployment wizard and it is by default set to 180 days.

EDIT:
So it seems the audit log in workflow is different than the audit log in deployment wizard. That setting is for actual audit log found under the adminstration 

And the audit log in workflow is indeed purged after the workflow setting "history in days"

 

 

Marcel Szimonisz

MarTech Consultant
for more tips visit my blog
https://www.martechnotes.com/

Prem_Kumar_Gane
Level 3
September 19, 2023

Hi @Shruti1 

Interim data of two executions i.e. temp data of the workflows will be deleted automatically based on your db cleanup scheduled time. By default it's scheduled to run at 4AM daily. 

History in 30 days is used to store the logs of activities used in the workflow. 

 

Thanks,

Prem Kumar Ganesan