INSERT INTO etl.ETL_SHELL_LOG    select date_format(now(), '%Y%m%d')  , '/etl/external/aaa.sh','/etl/external//etl/external/aaa.sh','total_mart_tb_ft_ofl_tr_hdr.iql','impala','2020-12-21 10:23:44' ,null,null,0,'running','','20201218 ~ 20201220',0  

    ======== 실행일자 : (2020-12-21 10:23:44) DailyBatch 시작(20201218 - 20201220) =======
    기준일수 : 3 (일정기간 반복적으로 수행되게 제어함)

SELECT DATE_FORMAT(INTERVAL 0 DAY + '20201218','%Y%m%d')  AS fdate,  DATE_FORMAT(INTERVAL ( 0 + 3 -1 ) DAY  + '20201218','%Y%m%d') as tdate  
SELECT SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-21 10:23:44' ,'2020-12-21 10:23:44')) diff  
■ util01.gsretail.com: total_mart_tb_ft_ofl_tr_hdr.iql 20201218 ~ 20201220 [00:00:00] 완료
   +
update etl.ETL_SHELL_LOG  set stat =1 ,status = 'finish' ,err_txt='',end_dtm = '2020-12-21 10:23:44' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-21 10:23:44' ,'2020-12-21 10:23:44')) WHERE full_shell_nm ='/etl/external//etl/external/aaa.sh' and sta_dtm ='2020-12-21 10:23:44'  
    ======== 실행일자 : (2020-12-21 10:23:44) DailyBatch 종료 (20201218 - 20201220) =======
 
INSERT INTO etl.ETL_SHELL_LOG    select date_format(now(), '%Y%m%d')  , '/etl/external/aaa.sh','/etl/external//etl/external/aaa.sh','total_mart_tb_ft_ofl_tr_hdr.iql','impala','2020-12-21 10:24:55' ,null,null,0,'running','','20201218 ~ 20201220',0  

    ======== 실행일자 : (2020-12-21 10:24:55) DailyBatch 시작(20201218 - 20201220) =======
    기준일수 : 3 (일정기간 반복적으로 수행되게 제어함)

SELECT DATE_FORMAT(INTERVAL 0 DAY + '20201218','%Y%m%d')  AS fdate,  DATE_FORMAT(INTERVAL ( 0 + 3 -1 ) DAY  + '20201218','%Y%m%d') as tdate  
SELECT SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-21 10:24:55' ,'2020-12-21 10:24:55')) diff  
■ util01.gsretail.com: total_mart_tb_ft_ofl_tr_hdr.iql 20201218 ~ 20201220 [00:00:00] 완료
   +
update etl.ETL_SHELL_LOG  set stat =1 ,status = 'finish' ,err_txt='',end_dtm = '2020-12-21 10:24:55' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-21 10:24:55' ,'2020-12-21 10:24:55')) WHERE full_shell_nm ='/etl/external//etl/external/aaa.sh' and sta_dtm ='2020-12-21 10:24:55'  
    ======== 실행일자 : (2020-12-21 10:24:55) DailyBatch 종료 (20201218 - 20201220) =======