An Enhancement Request 16422969 has been logged to include a “Delete All” button in a future release which had now been added to 184.108.40.206.500.
In order to make use of the option Delete All, an upgrade to 220.127.116.11.500 needs to be performed.
Please note that to apply Patch 18685108, 18.104.22.168 must be installed first.
If an upgrade is not a current option, a workaround is available.
Multiple taskflows can be deleted by using the check boxes, then click on the Delete Button on the Screen. It will delete all the taskflows which have marked for deletion.
Please note that Taskflows in Active State will not be deleted.
To delete all taskflows on in the application, please execute the below set of SQL Queries one by one.
Note: Prior to taking these steps ensure to backup the repository.
These queries will clean up all the existing taskflows and the dependency table entries. After performing this operation new taskflows can be created as required.
Note: After executing all the below Queries, there wont be any records with respect to Taskflows scheduling and executions as well.
Clean up SQL Queries:
delete from ces_process_def;
DELETE FROM CES_TASKS;
DELETE FROM CES_WF_INSTANCES;
DELETE FROM CES_ACL_INFO;
delete from QRTZ_CRON_TRIGGERS;
delete from QRTZ_SIMPLE_TRIGGERS;
delete from QRTZ_TRIGGERS;
delete from QRTZ_JOB_DETAILS;