How can I empty the publish queue via SQL?

Lee Clontz's Avatar

Lee Clontz

25 Jun, 2010 08:39 PM

We have a development instance that has 300 jobs sitting in the publish queue. I'd like to remove them all at once, but there's a foreign key relationship with the records in cxml_publishrequest that I'm not sure how best to overcome. Is there an SQL statement I can easily use to wipe out the publish queue?

Thanks!

  1. Support Staff 1 Posted by Tim on 25 Jun, 2010 08:53 PM

    Tim's Avatar

    Hi Lee,

    You should be able to clear your publish queue by issuing the following SQL queries in order:

    delete from cxml_publishrequest_dest;
    update cxml_publishrequest set prevId = null, nextid = null;
    delete from cxml_publishrequest;
    

    These should do the trick. You may wish to take a screen shot of the publish queue in case you want to place any of those jobs back in after the queries have been executed.

  2. Tim closed this discussion on 25 Jun, 2010 08:53 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac