Ask the Community
Groups
How to clear stale jobs in UB - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>How to clear hung backup jobs</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p>How to clear stale jobs which show active (hour glass) but are no longer warning.</p> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p> </p> <p><b>*** <i>Caution</i>: For advanced users only. ***</b></p> <p><b>*** May cause un-repairable damage! ***</b></p> <br><br>Run this command to update a hung or stale backup job which is showing as active however is not progressing. This command will update the backup status to show the backup as failed. <br><br>Example using backup number 54739 <pre class="code codeBlock" spellcheck="false" tabindex="0"> psql -U postgres bpdb -c "update bp.backups set status=21568 where backup_no=54738"</pre> <br><br> </article> </main>