--预置调度程序类
DELETE FROM t_sch_taskdefine WHERE FID = '3DKVSLRYU31/';
INSERT INTO t_sch_taskdefine(FID,FCREATETIME,FMODIFIERID,FRESCHEDULED,FMODIFYTIME,FCLASSNAME,FAPPID,FCREATORID,FNUMBER) VALUES ('3DKVSLRYU31/',NULL,0,'0',NULL,'kd.tmc.bei.business.task.DetailsGenHistoryBlanceTask','bei',0,'bei_DetailsGenHistoryBlanceTask');

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '3DKVSLRYQ=9B';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3DKVSLRYU31/','3DKVSLRYQ=9B','zh_CN','明细生成历史余额');
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '3DKVSLRYQ=9C';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3DKVSLRYU31/','3DKVSLRYQ=9C','zh_TW','明細生成曆史餘額');

--调度计划
DELETE FROM T_SCH_SCHEDULE WHERE FID = '3SI5G739+HSO';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FSUN,FTWO,FEIGHT,FNOV,FPLAN,FWED,FHOST,FCREATETIME,FTWENTYTWO,FFOUR,FMAR,FSEP,FENDTIME,FSIX,FMAY,FREPEATMODE,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSEVEN,FTWENTYSIX,FTHIRTEEN,FAUG,FDESC,FFIFTEEN,FTWENTYONE,FBYWEEK,FTUES,FMODIFIERID,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,FMODIFYTIME,FJUL,FDEC,FJUN,FFEB,FCREATORID) VALUES ('0','0','0','0',NULL,'0','0','0','0','0 26 10 20 12 ? 2023','0','172.19.110.191',{ts'2023-12-20  00:00:00'},'0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','n','0',NULL,'0','0','0','0','事件于2023-12-20 10:26:00执行一次。','0','0','0','0',1,'0','0','0','0','0','0','0','0','0','0','0','0','3SI5G70/2+0Q',{ts'2023-12-20  00:00:00'},'0','0','0','3SI5G739+HSO','0','0','0','0','0',NULL,'1','fcs_autocreate1703039194730_SKDP_S','0','0',15,'0',{ts'2023-12-21  00:00:00'},'0','0','0','0',1);

DELETE FROM t_sch_schedule_l WHERE FPKID = '3SI5G7DE7H5/';
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3SI5G739+HSO','3SI5G7DE7H5/','zh_CN','资金任务调度作业');

DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '3SI5G7DE3AX7';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3SI5G739+HSO','3SI5G70/2+0Q','3SI5G7DE3AX7',1);

DELETE FROM t_sch_schedule_m WHERE FENTRYID = '3SI5H6Y9CPY8';
INSERT INTO t_sch_schedule_m(FID,FMSGTYPE,FSNOTIFYTYPE,FSMSGCONTENT,FENTRYID,FSEQ) VALUES ('3SI5G739+HSO','FAILED,',' ',' ','3SI5H6Y9CPY8',1);

DELETE FROM t_sch_schedule_n WHERE FID = '3SI5G739+HSO';
INSERT INTO t_sch_schedule_n(FID,FSNOTIFYTYPE,FMSGRECEIVER,FSMSGCONTENT,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY,FSABORTED) VALUES ('3SI5G739+HSO',' ',0,' ','0',0,'0','1','0');

--调度作业
DELETE FROM T_SCH_JOB WHERE FID = '3SI5G70/2+0Q';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FTASKTRACE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FCREATETIME,FMODIFIERID,FTIMEOUT,FRETRYTIME,FMODIFYTIME,FRUNBYLANG,FCANSTOP,FCREATORID,FPARAMS,FRUNBYORGID) VALUES ('3SI5G70/2+0Q','kd.bos.ext.tmc.task.TmcScheduleTask','3FBZWKR4J=Y4',' ',1,'BIZ','0','1','fcs_autocreate1703039194730','0',' ',{ts'2023-12-20  00:00:00'},0,0,0,{ts'2023-12-20  00:00:00'},' ','0',0,'{"type":"0","intellSchemaidList":[{"Id":1844144827625783296}]}',0);

DELETE FROM T_SCH_JOB_l WHERE FPKID = '3SI5G702TJH0';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3SI5G70/2+0Q','3SI5G702TJH0','zh_CN','资金任务调度作业');

DELETE FROM T_SCH_JOB_n WHERE FID = '3SI5G70/2+0Q';
INSERT INTO T_SCH_JOB_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION,FABORTED) VALUES ('3SI5G70/2+0Q',0,'0','0',0,' ','1',' ',' ','0');


