Updating PR_SYS_QUEUES Status
I have entries in PR_SYS_QUEUES that are constantly reprocessing. Due to affect on database server archive process, I am planning to update PYITEMSTATUS to 'Broken-Process' via database script (there will be separate analysis to find root underlying issue and remediate). Just wanted to get feedback that this works as a possible solution even if it's not the ideal solution and the best practice for updating PR_SYS_QUEUES.
It should work since the stored procedure used by the agent queue processing checks for items that are in a Scheduled status and a date ready to be processed.
Keep up to date on this post and subscribe to comments