Preffered solution Check with the customer before applying the new solution (especially for points 2 and 3) 1. RealTimeDataTableSolution_generic_part.sql 2. views based on realtime tables: -> fact_v_realtime_customer_data.vw 3. views based on realtime tables: -> fact_v_realtime_data.vw 4. REALTIME_CUSTOMER_SCRIPTS_custom_part.sql 5. REALTIME_SCRIPTS_custom_part.sql 6. Enable the jobs after checking. 7. when make sure the jobs are working run following scripts from folder "views based on realtime tables": fact_v_realtime_customer_data.vw fact_v_realtime_data.vw In demand for maximum duration: 8. In absdatawarehouse run Check_Maximun_Run_Duration.sql -> BI_GIT\customers\JSG\ABSDATAWAREHOUSE\Check_Maximum_Run_Duration_JSG.sql 9. create table run: sys_user_create_table ABS_KILLED_SESSIONS.sql 10. create procedure: sys_user_abs_kill_stuck_realtime_load.prc 11. create a job: sys_user_create Job ABS_KILL_STUCK_REALTIME_LOAD_JOB.sql