Archive and Delete Session logs

[naga007]

Our requirement is to delete sessions logs which are older than 180days post-archiving. Blueprism in-product maintenance has this feature under System>Archiving, but it's super slow when dealing with large size of data (for us it's 300GB of data for >180days). With request, support team shared SQL script for SessionsLogsCleanup, but it will directly delete the logs without archiving. If anyone is familiar with this approach, pls share your inputs. Thanks!

[devneetmohanty07 · Accepted solution]

Hi @naga007 ,

If you already have received the script to delete the sessions from BP support team, you can modify the script to create a new script named differently. This script should have the INSERT and CREATE TABLE logic in a separate database that you can have created with the same table structure as the tables mentioned in the script provided to you. So ideally, what you can do is have a windows scheduler task or an Autosys job run in background at your defined interval and schedule and first trigger the modified script which would ideally create a backup of your data in the replicant database with required tables and then basically you can have the provided script triggered which would simply delete the tables. 

Please note, it is also possible that you keep the logics of both the scripts in on script as well where first you can execute the backup logic and then execute the deletion logic.

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------