The primary purpose of this research is to resolve the problem of ETL operation failure in execution of ETL (Extraction, Transformation and Loading) by the medical decision-making system due to data content, system factors and defective program design, thereby affect online daily operation of the application system and even customer complaint. This research first research and develop how to record in database, whether successful or not, the number of ETL file conversion program (including tool and self-wrote PL/SQL program) execution process, data status, and execution time; followed by designing control mechanism and write Script for voluminous table restoration for automatic execution by the system; afterwards followed by research and develop system automatic execution of restoration to stop only the affected application programs of the table and design a restoration mechanism. Lastly, through verification, this R&D result would correctly restore the data and table required by ETL procedure.