The following commands are recommend to be executed routinely to keep the DE database in healthy state.
- TRACELOG CLEANUP using cleanup script or command in <de_install_dir>/bin
Here are some examples of how to set up the jobs.
For MOVEHISTORYDATA, setup job using the default AGENT. You may want to move historical data that is older than one month to archive tables (H_ tables).
The DELETESTATUSMESSAGES is an important command that clears the status message tables. These tables can grow very fast in a busy environment.
The 'Arguments to pass' field has DE hostname, with port it is using, user and password of admin and the command with threshold.
//Configure how many days older statuesmessages to delete
var no_of_days = 7
var old_date = new Date();
old_date.setDate(old_date.getDate() - no_of_days);
APPL.date = (old_date.getYear()+1900)+'-'+eval(old_date.getMonth() + 1)+'-' +old_date.getDate()+' '+old_date.getHours()+':'+old_date.getMinutes()+':'+old_date.getSeconds();