How to Take Jobs Out of the Queue

Goal

I want to unqueue jobs that were previously queued. These jobs need to be un-queued before a restart occurs.

Why

I need to migrate or to restart Datameer. A lot of jobs are in the QUEUED state in Datameer and some are running. After migration and/or restart queued jobs remain queued or will start to run later. 

Learn

You can access the Datameer application MySQL database and check for jobs which are in the QUEUED and/or WAITING_FOR_OTHER_JOB state.

SELECT * FROM dap_job_execution
WHERE job_status = 0;

To clean the queue, it is recommended to set those jobs to CANCELED.

UPDATE dap_job_execution
SET job_status = 6
WHERE job_status = 0;
UPDATE dap_job_execution
SET job_status = 6
WHERE job_status = 5;