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 ...) |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
# select distinct status_id, count(job_id) from job_sandbox group by status_id; | # 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'); | + | # select status_id, job_id, job_name, service_name from job_sandbox |
| + | where status_id in ('SERVICE_PENDING', 'SERVICE_RUNNING'); | ||
</pre> | </pre> | ||
Latest 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');
