Skip to main content
Kofax

Kofax TotalAgility - Check the number of finished jobs to delete with Retention Policy enabled

Question / Problem: 

Job Retention policy is enabled at business/case process level, therefore, it does not have a system setting as per Document/Audit etc Retention Policy.  How do we check the number of finished jobs to delete with Retention Policy enabled?

Answer / Solution: 

Use the attached SQL "Number_of_jobs_to_delete_with_Retention_Policy_enabledv1.sql" (click here to download) to group by process the number of finished jobs with Retention Policy enabled.

Note: Ensure to update the TotalAgility and Finished databases names and dateadd function to use your Retention timeframe accordingly.