Difference between revisions of "Managing Scheduled Jobs"
From Opentaps Wiki
Jump to navigationJump to search (New page: 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 ...) |
m (Protected "Managing Scheduled Jobs": Sysop page [edit=sysop:move=sysop]) |
(No difference)
| |
Revision as of 17:11, 26 October 2009
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');
