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 "".
|