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.