Managing Scheduled Jobs

The ofbiz framework used in opentaps contains a job scheduling system which stores jobs and their parameters in JOB_SANDBOX and RUNTIME_DATA. Periodically, you should check the jobs and clear out duplicates which are pending or running, using these SQL queries:

# select distinct status_id, count(job_id) from job_sandbox group by status_id;

# select status_id, job_id, job_name, service_name from job_sandbox where status_id in ('SERVICE_PENDING', 'SERVICE_RUNNING');