update t_sch_taskdefine_l set FNAME = '费用-商旅集成-差旅壹号组织' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'ChaiLvYiHaoSyncDept');
update t_sch_taskdefine_l set FNAME = '费用-商旅集成-差旅壹号订单' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'ChaiLvYiHaoSyncOrder');
update t_sch_taskdefine_l set FNAME = '费用-商旅集成-差旅壹号人员' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'ChaiLvYiHaoSyncUser');
update t_sch_taskdefine_l set FNAME = '费用-商旅集成-携程城市' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'GetCTirpCityTask');



update t_sch_taskdefine_l set FNAME = '费用-商旅集成-订单转换低碳积分' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'GetTripBillAutoTask');
UPDATE t_sch_taskdefine SET FCLASSNAME='kd.fi.er.business.trip.task.common.GenOrderIntegralTask' WHERE FNUMBER='GetTripBillAutoTask';
update t_sch_job set FTASKCLASSNAME = 'kd.fi.er.business.trip.task.common.GenOrderIntegralTask',FSTATUS = '1' where FNUMBER = 'em_OrderConvertToIntegral_SKDJ_S';
update t_sch_schedule set FStatus='0' where FNUMBER = 'em_OrderConvertToIntegral_SKDP_S';


update t_sch_taskdefine_l set FNAME = '费用-商旅集成-未报销订单自动报销' where fid = (select fid from t_sch_taskdefine where FNUMBER = 'er_autoSubmitOrderBill');
UPDATE t_sch_taskdefine SET FCLASSNAME='kd.fi.er.business.trip.task.common.TripOrderBillAutoSubmitTask' WHERE FNUMBER='er_autoSubmitOrderBill';
update t_sch_job set FTASKCLASSNAME = 'kd.fi.er.business.trip.task.common.TripOrderBillAutoSubmitTask',FSTATUS = '1' where FNUMBER = 'em_UnreimbursedOrderConvertToBill_SKDJ_S';


DELETE FROM t_sch_taskdefine WHERE FID = '179TL=M=BQ1V';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('179TL=M=BQ1V','kd.fi.er.business.trip.task.common.SyncReqBillToTripTask','em','SyncReqBillToTripTask'); 

DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '179TL=M=B4VD';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('179TL=M=BQ1V','179TL=M=B4VD','zh_CN','费用-商旅集成-出差单同步'); 
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '179TL=M=B4VE';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('179TL=M=BQ1V','179TL=M=B4VE','zh_TW','費用-商旅集成-出差單同步'); 

DELETE FROM T_SCH_JOB WHERE FID = '179UDBP7O3A=';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FTIMEOUT,FRUNBYLANG,FSTATUS,FPARAMS,FRUNBYORGID,FNUMBER,FCONCURRENT) VALUES ('179UDBP7O3A=','kd.fi.er.business.trip.task.common.SyncReqBillToTripTask','179TL=M=BQ1V',1,'BIZ',0,' ','1',' ',0,'em_SyncReqBillToTripTask_SKDJ_S','1'); 

DELETE FROM T_SCH_JOB_L WHERE FPKID = '179UDBP7OOIR';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('179UDBP7O3A=','179UDBP7OOIR','zh_CN','费用-商旅集成-出差单同步'); 
DELETE FROM T_SCH_JOB_L WHERE FPKID = '179UDBP7OOIS';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('179UDBP7O3A=','179UDBP7OOIS','zh_TW','費用-商旅集成-出差單同步'); 

DELETE FROM T_SCH_SCHEDULE WHERE FID = '179UZB++O360';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FSUN,FTWO,FEIGHT,FNOV,FPLAN,FWED,FHOST,FTWENTYTWO,FFOUR,FMAR,FSEP,FENDTIME,FSIX,FMAY,FREPEATMODE,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSEVEN,FTWENTYSIX,FTHIRTEEN,FAUG,FDESC,FFIFTEEN,FTWENTYONE,FBYWEEK,FTUES,FSEVENTEEN,FSEVEN,FTWENTYFOUR,FMON,FTHIRTY,FTHREE,FFOURTEEN,FJAN,FNINETEEN,FTHUR,FTEN,FFRI,FJOBID,FSTARTTIME,FOCT,FAPR,FSIXTEEN,FID,FSAT,FONE,FTWENTYEIGHT,FTWENTYTHREE,FTWELVE,FNOWEEK,FSTATUS,FNUMBER,FTWENTYFIVE,FEIGHTEEN,FCYCLENUM,FTWENTYNINE,FJUL,FDEC,FJUN,FFEB) VALUES ('0','0','0','0',' ','0','0','0','0','0 30 0/12 * * ?','0','172.19.112.90','0','0','0','0',{ts'2099-11-19  23:30:00'},'0','0','h','0','d','0','0','0','0','事件将于2020-11-19 23:30:00起，
每12小时重复。
预计最近十次执行时间：
2020-11-20 00:30:00,
2020-11-20 12:30:00,
2020-11-21 00:30:00,
2020-11-21 12:30:00,
2020-11-22 00:30:00,
2020-11-22 12:30:00,
2020-11-23 00:30:00,
2020-11-23 12:30:00,
2020-11-24 00:30:00,
2020-11-24 12:30:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','179UDBP7O3A=',{ts'2020-11-19  23:30:00'},'0','0','0','179UZB++O360','0','0','0','0','0',' ','0','em_SyncReqBillToTripTask_SKDP_S','0','0',12,'0','0','0','0','0'); 

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '179UZB++OODH';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('179UZB++O360','179UZB++OODH','zh_CN','费用-商旅集成-出差单同步'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '179UZB++OODI';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('179UZB++O360','179UZB++OODI','zh_TW','費用-商旅集成-出差單同步'); 

DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '1EUE5WS=0DHS';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('179UZB++O360','179UDBP7O3A=','1EUE5WS=0DHS',1); 
