SELECT SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:43:53' ,'2020-12-20 15:44:14')) diff  
■ util01.gsretail.com: total_mart_tb_ft_ofl_tr_hdr.iql 20201220 ~ 20201220 [00:00:21] 완료
   +
update etl.ETL_SHELL_LOG  set stat =1 ,status = 'finish' ,err_txt='',end_dtm = '2020-12-20 15:44:14' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:43:53' ,'2020-12-20 15:44:14')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:43:53'  
    ======== 실행일자 : (2020-12-20 15:44:14) DailyBatch 종료 (20201220 - 20201220) =======
 
INSERT INTO etl.ETL_SHELL_LOG    select date_format(now(), '%Y%m%d')  , 'aaa.sh','/etl/external/aaa.sh','total_mart_tb_ft_ofl_tr_hdr.iql','impala','2020-12-20 15:46:36' ,null,null,0,'running','','20201216 ~ 20201219',0  

    ======== 실행일자 : (2020-12-20 15:46:36) DailyBatch 시작(20201216 - 20201219) =======
    기준일수 : 3 (일정기간 반복적으로 수행되게 제어함)

SELECT DATE_FORMAT(INTERVAL 0 DAY + '20201216','%Y%m%d')  AS fdate,  DATE_FORMAT(INTERVAL ( 0 + 3 -1 ) DAY  + '20201216','%Y%m%d') as tdate  
SELECT SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'2020-12-20 15:48:56')) diff  
■ util01.gsretail.com: total_mart_tb_ft_ofl_tr_hdr.iql 20201216 ~ 20201218 [00:02:20] 완료
   +
SELECT DATE_FORMAT(INTERVAL 1 DAY + '20201218','%Y%m%d')  AS fdate,  DATE_FORMAT(INTERVAL ( 1 + 3 -1 ) DAY  + '20201218','%Y%m%d') as tdate  
▶ util01.gsretail.com: total_mart_tb_ft_ofl_tr_hdr.iql 20201219 ~ 20201219 impala 적재 fail
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
update etl.ETL_SHELL_LOG  set stat =3 ,status = 'fail' ,err_txt='',end_dtm = '' ,ned_tm_inf = SEC_TO_TIME(TIMESTAMPDIFF(second,'2020-12-20 15:46:36' ,'')) WHERE full_shell_nm ='/etl/external/aaa.sh' and sta_dtm ='2020-12-20 15:46:36'  
INSERT INTO etl.ETL_SHELL_LOG    select date_format(now(), '%Y%m%d')  , 'aaa.sh','/etl/external/aaa.sh','total_mart_tb_ft_ofl_tr_hdr.iql','impala','2020-12-20 15:49:53' ,null,null,0,'running','','20201220 ~ 20201220',0  

    ======== 실행일자 : (2020-12-20 15:49:53) DailyBatch 시작(20201220 - 20201220) =======
    기준일수 : 3 (일정기간 반복적으로 수행되게 제어함)

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