Last Updated on

Ephesoft provides another way to perform clean-up automatically that can be configured as a cron job using procedure mentioned below.
Following are steps to configure Ephesoft clean up SQL Procedure:-
1. Stop the Ephesoft server if it is currently running.
2. Create a clean-up stored procedure for the respective database by running the attached SQL query in query browser. (see Downloads below)
3. Change the following properties in ‘Application/WEB-INF/classes/META-INF/dcma-reporting’.
a. Inside the ‘’ modify the following properties:-
i. is_reporting_and_cleanup_enabled=true
ii. export_report_data_switch=false (set to false when reporting is not needed else set to true)
b. Inside the ‘’ modify the following property:-
iii. 0 1 * * ? *
4. Restart the Ephesoft server.



Stored Procedure for 3.1+:


Was this article helpful to you?

Walter Lee