Purge jobs executions from Rundeck H2 Database

purge_executions_rundeck.sql

DELETE FROM PUBLIC.REFERENCED_EXECUTION;

DELETE FROM PUBLIC.BASE_REPORT;
	
DELETE FROM WORKFLOW_WORKFLOW_STEP wws
WHERE wws.WORKFLOW_COMMANDS_ID IN (
	SELECT WORKFLOW_id FROM EXECUTION
);

DELETE FROM WORKFLOW_STEP ws
WHERE ws.ID NOT IN (
	SELECT wws.WORKFLOW_STEP_ID FROM WORKFLOW_WORKFLOW_STEP wws
);

DELETE FROM EXECUTION;

DELETE FROM WORKFLOW w 
WHERE w.ID NOT IN (
	SELECT wws.WORKFLOW_COMMANDS_ID FROM WORKFLOW_WORKFLOW_STEP wws
);