Deleting the [BPAWorkqueueitem] affect the any items in blueprism data

[vipularora007]

Hi 
Can anyone guide any how to delete the BPAWorkqueueitem  from database.
If we delete the BPAWorkqueueitem table from database what data is impacting on blueprism 

• It will affect the schedules or any schedules previously created  can be change .?

[PvD_SE]

Hi Vipul,

Just wondering: Why would you want to remove it from the database, if you can easily remove it directly in Control Room?

Happy coding!
---------------
Paul
Sweden

[SteveBoggs]

We would strongly recommend against deleting any tables in a Blue Prism database.

Our recommendations for removing Work Queue Items can be found here: "How do I remove completed Work Queue items from the Work Queue?"

As suggested in the article, we have a database script called "trim-queues.sql" that can be provided on request from Support, which will trim data in the BPAWorkQueueItem table and truncate the BPAWorkQueueLog table. The BPAtag table is also trimmed, removing any tags no longer being used by work queue items.

More information on these scripts can be found here.