delete   from T_SCH_SCHEDULE  where FId = '3A+W9609+BRC';
delete  from T_SCH_SCHEDULE_N  where FId = '3A+W9609+BRC';
delete from T_SCH_SCHEDULE_L where fid = '3A+W9609+BRC';
delete   from T_SCH_SCHEDULE_ENTRY  where FId = '3A+W9609+BRC';
delete  from T_SCH_TASKDEFINE  where FId = '3A+VYG8S8H4C';
delete  from T_SCH_TASKDEFINE_L  where FId = '3A+VYG8S8H4C';
delete  from T_SCH_JOB  where FId = '3A+W6V=F/4Z4';
delete  from T_SCH_JOB_N  where FId = '3A+W6V=F/4Z4';
delete  from T_SCH_JOB_L  where FId = '3A+W6V=F/4Z4';

INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3A+VYG8S8H4C','kd.fi.er.business.trip.task.travelno1.TTripCheckingImageInfoTask','em','TTripCheckingImageInfoTask');
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '3A+VYG8S6FP3';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3A+VYG8S8H4C','3A+VYG8S6FP3','zh_CN','获取月结账单影像');
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '3A+VYG8S6FP4';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3A+VYG8S8H4C','3A+VYG8S6FP4','zh_TW','獲取月結賬單影像');

INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('3A+W6V=F/4Z4','kd.fi.er.business.trip.task.travelno1.TTripCheckingImageInfoTask','3A+VYG8S8H4C','0',13466739,'BIZ','1','em_ChaiLvYiHapCheckingSynImageInfo_SKDJ_S','1','1',0,0,' ','0','{}',0);


INSERT INTO T_SCH_JOB_N(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION) VALUES ('3A+W6V=F/4Z4',0,'0','0',0,' ','1',' ','调度作业通知');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '3A+W6V=F/5MD';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3A+W6V=F/4Z4','3A+W6V=F/5MD','zh_CN','费用-商旅集成-差旅壹号根据账单编号查询行程单/火车票/发票影像信息');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '3A+W6V=F/5ME';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3A+W6V=F/4Z4','3A+W6V=F/5ME','zh_TW','費用-商旅集成-差旅壹號根據賬單編號查詢行程單/火車票/發票影像信息');


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 0 0 21 * ?', '0', '172.19.79.160', '0', '0', '0', '0',
        {ts '2099-12-31  00:00:00'}, '0', '0', 'm', '0', 'd', '0', '0', '0', '0',
        '事件将于2023-05-21 00:00:00起，每1月的21日重复。  预计最近十次执行时间：  2023-05-21 00:00:00,  2023-06-21 00:00:00,  2023-07-21 00:00:00,  2023-08-21 00:00:00,  2023-09-21 00:00:00,  2023-10-21 00:00:00,  2023-11-21 00:00:00,  2023-12-21 00:00:00,  2024-01-21 00:00:00,  2024-02-21 00:00:00',
        '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '3A+W6V=F/4Z4',
        {ts '2023-05-21  00:00:00'}, '0', '0', '0', '3A+W9609+BRC', '0', '0', '0', '0', '0', ' ', '0',
        'em_ChaiLvYiHaoCheckingSynImageInfo_SKDP_S', '0', '0', 1, '0', '0', '0', '0', '0');



DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '3A+W9609+BRD';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3A+W9609+BRC','3A+W6V=F/4Z4','3A+W9609+BRD',1);

INSERT INTO T_SCH_SCHEDULE_n(FID,FSNOTIFYTYPE,FMSGRECEIVER,FSMSGCONTENT,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('3A+W9609+BRC',' ',0,' ','0',0,'0','1');


DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '3A+W9609+B23';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3A+W9609+BRC','3A+W9609+B23','zh_CN','费用-商旅集成-差旅壹号根据账单编号查询行程单/火车票/发票影像信息');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '3A+W9609+B24';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3A+W9609+BRC','3A+W9609+B24','zh_TW','費用-商旅集成-差旅壹號根據賬單編號查詢行程單/火車票/發票影像信息');