How to clear all active publish jobs

espanae's Avatar

espanae

23 Oct, 2014 09:22 PM

Hi,
I wrote a web services script to publish all pages related to a template. The publish queue displays these jobs as individual pages (rather than one job) and I recently published a template with 3,000 pages. In the future, is there a way to delete the Active Jobs in the queue without clicking on each "X" button?

Thanks,
Erik

  1. Support Staff 1 Posted by Tim on 23 Oct, 2014 10:39 PM

    Tim's Avatar

    Hi Erik,

    There isn't a way to do this through the interface at this time. Please be sure to vote/comment on this related idea when you have the chance.

    In the meantime, if you would really like to clear all jobs from the publish queue, you can execute the following queries in order:

    delete from cxml_publishrequest_dest;
    delete from cxml_publishrequest_config;
    update cxml_publishrequest set prevId = null, nextid = null;
    delete from cxml_publishrequest;
    
    Hope this helps!

    Let me know if you have any further questions.

  2. 2 Posted by espanae on 24 Oct, 2014 02:18 PM

    espanae's Avatar

    Thanks for sharing the idea exchange link. I voted it up.

  3. espanae closed this discussion on 24 Oct, 2014 02:18 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