Question
3
Replies
444
Views
Moody’s Shared Services Inc
Posted: December 26, 2018
Last activity: January 10, 2019
Closed
Solved
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.