Database Maintenance

[wayyy (Wahyu Muhammad Nouval)]

How i Can Housekeeping Database in UiPath orchestrator 2022.10 ? i’ve been folowing the documentation in Orchestrator - Maintenance Considerations and i have been running the script, and script sample to cleanups the log queue but the table of “QueueItems” not clean up

[pikorpa (Piotr Kołakowski)]

Hey,
did you try this method?

Database Maintenance For Orchestrator

Procedure for Database maintenance and deletion of data of more than 30 days. Step1 : Take back up of PROD DB (UiPath) from the database server Step 2: Run the queries to delete the rows in table DELETE FROM [dbo]. [AuditLogEntities] WHERE AuditLogId in (select Id from dbo.auditlogs where DateDiff(day, ExecutionTime, GetDate()) > 30) Delete from dbo.auditlogs where DateDiff(day, ExecutionTime, GetDate()) > 30 DELETE FROM [dbo]. [AuditLogEntities] WHERE AuditLogId < ????? DELETE FROM [dbo].[jo…

[wayyy (Wahyu Muhammad Nouval)]

okay i’ll try it this methode , thanks sir