In the queues, you can see that a job has a status of ‘Processing’. From your knowledge of eB, you suspect thisis wrong as the job appears to have been running for much more than usual.
The time that this is usually seen is when a database isbacked up, a job is processing. Thedatabase is then restored into a testing arena, and the status of that job isstuck at processing.
In production environments issues like this can appear ifthe database goes off-line unexpectedly.
Here is an example of a Mail job:
And a ProjectWise job.
Most times it is not an issue, because the job is ignored, and eB will process the next ‘ready’ job in the queue. However, in the case of some job types, this might be having an impact on other jobs in the same queue because theproperties of the queue allow only one job to run at a time. Often the case with the Work Queue Service settings.
So, below are the steps required to remove the job from the queue.
If the job is in the Work Queue, you can right click on the‘processing’ job, and select ‘Cancel Job’
You will be prompted to confirm you want to cancel the job:
Do not be surprised if you get a message similar to thefollowing:
In some queues (mail for example), the cancel job will noteven appear. And this is due to thecoding behind the scenes, relating to how the queue is handled.
So, the way to get past this issue, is to update thedatabase tables directly.
The table concerned is the queue_jobs table.
If you run the following you will get an idea of what thecontents look like:
Select * from queue_jobs
Useful things to note are:
The jobtypeId column
To get a full list, run the following SQL:
Select * from jobtypes
You will see similar to this:
i.e. so if I am looking for an e-mail job, then thejobtype_id will be 4
and the Status column
So to locate your troubled job, you could simply try:
Select * from queue_jobs where status = 'I'
Or even more specific:
Select * from queue_jobs where status = 'I' and jobtype_id = '1001'
(where you are investigating a ProjectWise job)
The goal is to locate the job_id value.
Once you have it, we need to change the status from ‘InProgress’ to ‘Error’, so:
set status = 'E' where job_id ='1815525'
In the SMC, you will now see that you job is now set to ‘Error’
The job can now be safely deleted, or resubmitted.