Explain the procedure to execute reports 'After ETL'. What is the settings to be made?
The 'After ETL' schedule for Reports, Alerts & Scheduled Mail is now taken care in such a manner that it is initiated from ARC itself. One Quartz thread will be created at the start of the Tomcat. This thread will start running from 12 AM midnight until it finds the ETL status as 'YES' for every 15 minutes. It will check the table AFTER_ETL_STATUS for the column ETL_COMPLETED. Once it finds the status as 'Y', the thread will change the ETL status to 'N' and starts executing the 'after ETL' jobs. After executing all the jobs, it will create another thread that will start running from the next day midnight. Once the new thread begins, the earlier thread will stop. The changes that have to be performed as part of the ETL/Application is as follows: From the ETL Perspective, create a table named AFTER_ETL_STATUS with column ETL_COMPLETED of nvarchar(1). The table script is as follows: CREATE TABLE AFTER_ETL_STATUS ( ETL