Bulk Delete Complete/Failed Scheduled Actions Manually???

#476187
  • Resolved VannDigital
    Rank Math free

    I got a good number of complete and failed scheduled actions from months ago that were never deleted.

    Is there a way I can do a manual bulk delete of said scheduled actions??? 🤔

Viewing 9 replies - 1 through 9 (of 9 total)
  • Hello,

    Thank you for contacting Rank Math support and bringing your concern to our attention.

    Yes, you can do so by selecting multiple rows and deleting them in bulk. Please refer to my video screencast: https://i.rankmath.com/v/vPI06x

    Hope that helps and please do not hesitate to let us know if you need our assistance with anything else.

    VannDigital
    Rank Math free

    Is there a way I can manual bulk delete of 237109 failed and 77142 complete scheduled actions in 1 sweep??? 🤔

    Anas
    Rank Math business

    Hello,

    To delete them all at once, you can access the database and delete the entries from there.

    You can use the following SQL query to delete the completed and failed actions:

    DELETE FROM wp_actionscheduler_actions WHERE status=’complete’ OR status=’failed’

    Please make sure to replace the wp_actionscheduler_actions with the name of your action scheduler table.

    If you are not sure, we can delete those on your website.

    Please edit the first post on this ticket and include your WordPress & FTP logins in the designated Sensitive Data section.

    Please do take a complete backup of your website before sharing the information with us.
    Sensitive Data Section

    It is completely secure and only our support staff has access to that section. If you want, you can use the below plugin to generate a temporary login URL to your website and share that with us instead:

    https://wordpress.org/plugins/temporary-login-without-password/

    You can use the above plugin in conjunction with the WP Security Audit Log to monitor what changes our staff might make on your website (if any):

    https://wordpress.org/plugins/wp-security-audit-log/

    We really look forward to helping you.

    VannDigital
    Rank Math free

    So, I got that working.

    Can I apply this to wp_actionscheduler_logs as well???

    I’m asking since I got 814697 rows in the table…

    Hello,

    Yes, you can clear the data there as well. Just ensure you have conducted a backup of your database first.

    If you prefer to adjust the purge time so your action scheduler log will not always fill up, you can make use of this filter code:

    add_filter( 'action_scheduler_retention_period', 'wpb_action_scheduler_purge' );
    /**
     * Change Action Scheduler default purge to 1 week
     */
    function wpb_action_scheduler_purge() {
     return WEEK_IN_SECONDS;
    }

    Hope that helps and please do not hesitate to let us know if you need our assistance with anything else.

    VannDigital
    Rank Math free

    Got it!!!

    Thanks again!!!

    Anas
    Rank Math business

    Hello,

    We are glad we could address your concerns. If you have any other questions in the future, know that we are here to help you.

    If you don’t mind me asking, could you please leave us a review (if you haven’t already) on https://wordpress.org/support/plugin/seo-by-rank-math/reviews/#new-post about your overall experience with Rank Math? We appreciate your time and patience.

    If you do have another question in the future, please feel free to create a new forum topic, and it will be our pleasure to assist you again.

    Thank you.

    Will do!!!

    Hello,

    Thank you so much for leaving us a review. We really appreciate it.

    If you have any further questions, please feel free to start a new forum discussion, and it will be our pleasure to assist you once more.

    Thank you.

Viewing 9 replies - 1 through 9 (of 9 total)

The ticket ‘Bulk Delete Complete/Failed Scheduled Actions Manually???’ is closed to new replies.