Managing Scheduled Jobs

From Opentaps Wiki
Revision as of 17:11, 26 October 2009 by Sichen (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to 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');