https://docs.opentaps.org/docs/index.php?action=history&feed=atom&title=Managing_Scheduled_Jobs 2026-04-30T05:27:29Z Revision history for this page on the wiki MediaWiki 1.32.1 https://docs.opentaps.org/docs/index.php?title=Managing_Scheduled_Jobs&diff=4742&oldid=prev 2009-10-26T17:11:31Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 17:11, 26 October 2009</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l3" >Line 3:</td> <td colspan="2" class="diff-lineno">Line 3:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># select distinct status_id, count(job_id) from job_sandbox group by status_id;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div># select distinct status_id, count(job_id) from job_sandbox group by status_id;</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div># select status_id, job_id, job_name, service_name from job_sandbox where status_id in ('SERVICE_PENDING', 'SERVICE_RUNNING');</div></td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div># select status_id, job_id, job_name, service_name from job_sandbox  </div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">  </ins>where status_id in ('SERVICE_PENDING', 'SERVICE_RUNNING');</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/pre&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/pre&gt;</div></td></tr> </table>

Sichen https://docs.opentaps.org/docs/index.php?title=Managing_Scheduled_Jobs&diff=4741&oldid=prev 2009-10-26T17:11:11Z

<p>Protected &quot;<a href="/docs/index.php?title=Managing_Scheduled_Jobs" title="Managing Scheduled Jobs">Managing Scheduled Jobs</a>&quot;: Sysop page [edit=sysop:move=sysop]</p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr class="diff-title" lang="en"> <td colspan="1" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #222; text-align: center;">Revision as of 17:11, 26 October 2009</td> </tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

Sichen https://docs.opentaps.org/docs/index.php?title=Managing_Scheduled_Jobs&diff=4740&oldid=prev 2009-10-26T17:11:07Z

<p>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 ...</p> <p><b>New page</b></p><div>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:<br /> &lt;pre&gt;<br /> # select distinct status_id, count(job_id) from job_sandbox group by status_id;<br /> <br /> # select status_id, job_id, job_name, service_name from job_sandbox where status_id in ('SERVICE_PENDING', 'SERVICE_RUNNING');<br /> &lt;/pre&gt;</div>

Sichen