View Only
  • 1.  Workflow purge recommendation

    Posted 09-20-2021 12:18 PM

    I'm planning to implement Workflow purge policy across the two business units. Have anyone implemented any policy or have any recommendation on this?  Any advise on this will help us.


    Dinesh Singh
    HR Systems Administrator
    Loudoun County Government
    Leesburg VA

  • 2.  RE: Workflow purge recommendation

    SIG Leader
    Posted 09-21-2021 08:11 AM
    Do it in non-production first!
    If you have more than a few months to purge, do the initial purge in small increments.
    Once completed, have the dba's examine the workflow tables.  Make sure there is not a lot of empty space at the beginning.

    Michael Brown
    Database Administrator
    Burlington NC
    (859) 371-4423 x3353

  • 3.  RE: Workflow purge recommendation

    Posted 09-21-2021 09:46 AM
    I agree with Mike about running in test first and purge small chunks initially but once you are caught up then you should schedule the purge requests to purge all completed workflows. We have different purge policy for different types of workflows. For HR workflows we have created a set with  "Complete Defunct HR Workflow Processes" and Purge Obsolete Workflow and this helps clear the stuck workflows before purging. This helps a lot.

    Manish Bahel
    Team Lead
    State Corporation Commission
    Richmond VA
    (804) 371-2076