Cleaning the jobslist

[Vircos]

I tried to create a jobstlist cleaner which will clean up the jobslist and the related audits, tasks and processattributes. However some of the provided custom resources do not support looping through a table, deleting rows or updating the table.

I want to clean this up because by testing the workflowprocess in forms the jobslist has grown a lot.

Is there a way to clean up the jobslist and the related items?

[Wai]

You can remove them from the UFSREPOSITORY database tables by creating and executing a SQL script with the following statements:

delete from workflow_attribute_values;
delete from workflow_history;
delete from workflow_job;
delete from workflow_nodeenactment;
delete from workflow_workitem;
delete from workflow_workstream;

These statements will remove all your jobs, so only use in a development or testing environment.

You can alter the statements to include the Process Name/ID or the Job ID in the Where clause.

Hope that helps.

[Vircos]

It does, I didn't thought about working directly in the SQL database.

Thanks again Wai

[Jon]

Also need to add:

delete from workflow_table_attr_values;