Administration Guide › System Maintenance › Purge Data › Purge Workpoint Jobs Associated with a Workflow

Purge Workpoint Jobs Associated with a Workflow

CA GovernanceMinder uses Workpoint to monitor and control business workflows by creating a certification item for each privilege in a certification.

To reduce the Workpoint database size, delete Workpoint job records for completed workflows.

Follow these steps:

1. Open an SQL command prompt, connect to the Workpoint database, and run the following command:

   update WP_PROCI set LU_ID = 'Delete Job' where PROC_STATE_ID = 5;
   

   This command marks all completed jobs for deletion.

2. Execute the following command:

   execute spWP_DELETE_JOBS;
   

   This command deletes the marked jobs.

   You have marked and deleted completed jobs on the Workpoint database.