'Is there any way to get publishing queue in sitecore?

Problem is that I use a 5.2 Sitecore, and when I start to publish something, it only shows the publishing window and a "Queued" message. There is a chance that some people full published several times(that means 15000 items and 4 slaves), and the publishing queue is stuck. The restart of the webserver/app pool is not an option. Any experiences in sitecore publishing errors? something like this



Solution 1:[1]

So the final "solution" was to be the AppPool restart. Shame that the full publish stuck the sitecore shell, but the db browser could publish. Whatever, think I should contact to some sitecore support guy. BTW thanks Andrew&Kim!

Solution 2:[2]

When this happens to me, I normaly wait until the publishing is done. But the problem is that noone knows how long time it will take. Sometimes a reboot of the server accually does the trick, because the publish then dies. You could try to restart the server (if you have that opportunity of course) and then see if it helps. Otherwise ou have to be patient and wait until the publish queue is empty again.

Solution 3:[3]

It is possible to see the publishing queue on sitecorerocks - the visual studio sitecore plugin --> there is a job viewer that shows all the publishing task currently running plus the indexing task

Solution 4:[4]

AppPool restart is the way to go if you would like to "kill" the publishing operation.

  1. Open IIS
  2. Expand the main node
  3. Select "Application Pools"
  4. Find and select the worker process that your site uses
  5. On the right hand side hit "Recycle" under "Application Pool Tasks" header

You can also take a look at (your site)/sitecore/admin/PublishQueueStats.aspx, or (your site)/sitecore/admin/jobs.aspx - take a look on a file system, see what other administrative tools available for you in "(your web root)/sitecore/admin" folder. Might find some gems!

Solution 5:[5]

Yes, you can see all items in publish queue by using code. There is a way to get the list of item IDs in publish queue using API (Sitecore.Kernel.dll).

IdList publishQueue = Sitecore.Publishing.PublishManager.GetPublishQueue(startDate, ToDate, Context.CurrentDatabase)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 misnyo
Solution 2 Kim Andersen
Solution 3 eloycm
Solution 4 Sasha
Solution 5 Abdullah Ayoub