Queue Job Status shows “Waiting to be processed” and then never completes

To resolve this problem, set the SQL Retry Limit value to the default value of 5 and then restart the Microsoft Office Project Server Queue Service. 

To do this, follow these steps:

1. Set the SQL Retry Limit value to the default value of 5. 

To do this, follow these steps:

• a. On the Microsoft Office Project Web Access home page, click Server Settings.
• b. On the Server Settings page, under Queue click Queue Settings.
• c. On the Queue Settings page, change the SQL retry limit to 5.
• d. Click Save.

2. Restart the Microsoft Office Project Server Queue Service. 

To do this, follow these steps:

• a. From the server that is hosting Microsoft Office Project Server 2007, click Start, and then click Run.
• b. In the Run dialog box that appears, type “services.msc” without the quotation marks and then click OK.
• c. In the Services window, right-click Microsoft Office Project Server Queue Service and then click Stop. After the service has stopped, right-click it again and then click Start.