Tried all suggestions, no luck with "Waiting to be Processed" issu

[JLawrence]

I have read a lot of posts and articles and tried pretty much everything that
was suggested:

Stop and Start the Queue Service
Stop and Start the Sharepoint Timer Service
Make sure time is correct on both the SQL and Project/SP server
Reboot the Server

However none of these suggestions have worked. Regardless of what I do, all
my jobs are still in the queue with a status of "Waiting to be Processed".
Any other ideas of what I could do to get these jobs to process? Are there
some logs I can look at to see what is holding up these jobs?

 

[Marc Soester [MVP]]

Jeremy, it sounds like one of your queue jobs holds the rest up. I would go
and look for the queue job with ID 1 and delete this job, since you already
tried evertying else. This should release the rest of your queue jobs which
should be processes once you delete the job 1. Please note, that since you
delete the job ID 1, this job will not be processes. Make a note of the
project before you delete it and once you deleted the job, republish this
project and if required re-du the changes that did not go through. No this
is a "radical" way of clearing the queue, but somethimes the only way to
release the other jobs. I would also check the event log before I delete the
job, there may be some information that can resolve the issue in a different
way. I would also make sure to have SP2 installed since you experience these
issues. Many of those are resolved in SP2.

Hope this helps

 

[JLawrence]

I have cancelled all jobs. Now I only see one job in a cancelled state in my
queue. Should they all be gone or is it being in a cancelled state and still
showing up in the queue ok?

 

[Jonathan Sofer [MVP]]

When you go to the Manage Queue page it will always default to show all job
states except "Success" and only for the current date.

You then need to modify the settings in the top section and refresh the
queue in order to see jobs before today and jobs that are successful. If
you have jobs that were cancelled today then those jobs will still show up
in Manage Queue until tomorrow since tomorrow the date filter will change to
tomorrow.

It is also important as Marc Soester said to verify that you are viewing all
the troublesome queue jobs by looking at the queue job ID. If you don't see
ID 1 you need to change the date range to farther in the past in order to
find the culprit.

http://www.epmcentral.com/articles/ps07queuesystem.php

Make sense?