Workflow to deactivate Keep Interim Results from other workflows?

[god_prophet]

Would it be possible to create a Workflow that would query all workflows that have the option: Keep Interim Results, and deactivated?

If so, how? What table to target?

[_Manoj_Kumar_]

Hello @god_prophet 

Yes, Just query the xtk:workflow schema and look for the value of keepResults column

[god_prophet]

Hi @_Manoj_Kumar_ I don't see the Keep Results field... 
What could be this  happening?

[ParthaSarathy · Accepted solution]

Hi @god_prophet ,

Refer the below post on 'Tuesday tech bytes' and configure the same to fetch all the workflows where keep interim is enabled and disable it.

https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic/tuesday-tech-bytes-adobe-cam...