Remove Pending Items in Work Queue

[PrithvirajD]

I have a requirement to remove 9 million Pending records from the Work Queue with specific key filter. Due to high volume, using Internal VBO with Key Filter is not working as it searches all records everytime. Is there any other suggestions to accomplish this task?

------------------------------
Prithviraj D
------------------------------

[bclayton1896]

I would open a support ticket with Blue Prism. Most likely they can provide a SQL script approach to help you with this task. 

------------------------------
Brian Clayton
Applications Consultant
The Auto Club Group
America/Dearborn MI
313-336-1896
------------------------------

[grbanares]

If you have the right to access the database and knowledgeable on scripting, you can potentially run SQL command to delete the pending items from the queue table. Otherwise, work with your DBA as doing it directly from db will be the fastest way to do it.

If you don't have the capacity to do it and in doubt, please log a ticket with Blue Prism Support and they should be able to guide you properly with correct script to run and/or direct you to step that is more appropriate to your scenario.

Good luck! 😉

------------------------------
Genold Bañares
Head of Automation Development
Virtual Blue
Auckland, New Zealand
------------------------------