EnterWorks - ETT 146 - How to Purge Deleted Work Items from EPX Workflows

When work items are deleted from a workflow instead of being purged (which removes all work items), the database table records representing those work items are not deleted.  Instead, the status of those records are changed to DELETED.  If the number of deleted work items is sufficiently large (tens of thousands), performance of active work items may be affected detrimentally.  This may result in some high volume/activity workflows being affected to the point they begin to fail, which could snowball to all workflows within EPX.

A SQL Stored procedure has been created that can report the number of deleted work items within specific or all workflows, list from which activities those work items were deleted, or purge the deleted work items which will free up storage space and improve workflow performance.

This session shows how to use the SQL stored procedure.

Prerequisites - ETT 002, ETT 003