×
Menu
Search
 
   
   
   
 

Delete old test execution job

aqua stores test execution scripts in the database, which may expand the memory of the database. These can be deleted carefully quiet time without heavy transactions on database. For that we configure the web.config on aqua Server.
 
Here, you add the following keys like into existing section appSettings and don't remove existing ones.
 
Example:
 
<appSettings>
<add key="DBCleanupWorkerModules" value="ProcessElements"/>
<add key="DBCleanupWorkerStartTime" value="00:00:00"/>
<add key="DBCleanupWorkerEndTime" value="23:59:59"/>
<add key="DBCleanupWorkerPeriod" value="60000"/>
<add key="DBCleanupWorker.ProcessElementChunkSize" value="50"/>
<add key="DBCleanupWorker.ProcessElementOlderThanDays" value="1"/>
<add key="DBCleanupWorker.ProcessElementJobTypes" value="Ranorex;SoapUI"/>
</appSettings>
 
 
DBCleanupWorkerModules
The default value is always "ProcessElements"
DBCleanupWorkerStartTime
Here you can define, when the DB Cleanup Worker should start with CleanUp periode.
DBCleanupWorkerEndTime
Here you can define, when the DB Cleanup Worker should stop Cleanup period.
DBCleanupWorkerPeriod
This defines, in which time interval in ms the cleanup should be triggered.
60000 means 60 seconds.
DBCleanupWorker.ProcessElementChunkSize
This defines, how many automation scripts should be deleted in one time interval.
DBCleanupWorker.ProcessElementOlderThanDays
This defines, which automation scripts should be deleted depending on execution date. The value should be greater than 0.
DBCleanupWorker.ProcessElementJobTypes
This defines, which automation scripts should be deleted depending on test automation technologie. The values can be
JMeter, Ranorex, SoapUI, Database, QTP, PowerShell, UnixShell, Jenkins, UFT
and should be seperated by ";" without "".