Preface: the Upgrade assigned and claimed tasks
jobs are responsible for the assignment of tasks and are run by the STATS
engine. They are run one by one
and are usually supposed to take 1 second or 2. It is not possible to increase the number of STATS engine and make multiple assignment jobs run at the same time.
So if one of these Job is running for a long time and not completing, all the other assignment jobs are blocked. Other type of background jobs like export or import are unaffected by the assignment jobs because they are run by the Background Engine
and not by the STATS engine. So even if they all display on this page, they are run differently and are not interfering with each other.
To address the issue described above, try following steps:
1- Select several of the Upgrade assigned and claimed tasks
below the one executing that are in status In Queue
and click on Change Priority.
2- Set the priority to 4 and click OK
3- Go to the WorldServer Database and set the job in Executing status On Hold
. To do so, In the Database, use the Job ID
corresponding to the Job and run this query in the Database to send the job to status On Hold (STATUS=3).
corresponds to the Job ID column. Assuming that the Job ID is 8590845, run this query (if you work in Oracle, commit):
update BACKGROUNDTASKS set STATUS=3 where BACKGROUNDTASKID=8590845
4- Now go back to the Background Jobs page and refresh. You should see the Job that was executing before in On hold
status. The other jobs should start to be executed. Once all are executed, select the one On hold
and click on resume to restart it.