Managing Scheduled Jobs

From Opentaps Wiki

Jump to: navigation, search

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');

© Open Source Strategies, Inc. Development of this documentation site is sponsored by Open Source Strategies, Inc.
Help support opentaps with a subscription to this documentation site.