-- 调度任务类名
DELETE FROM t_sch_taskdefine WHERE FID = '31DW//PXU8I1';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('31DW//PXU8I1','kd.bos.bd.task.BaseDataAutoUpgradeTask','base','autoUpgradeTask'); 

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '31DW//PXTGWS';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('31DW//PXU8I1','31DW//PXTGWS','zh_CN','受控基础资料自动升级模型'); 
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '31DW//PXTGWT';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('31DW//PXU8I1','31DW//PXTGWT','zh_TW','受控基礎資料自動升級模型'); 


-- 调度作业
DELETE FROM T_SCH_JOB WHERE FID = '31G6FU0UUD//';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('31G6FU0UUD//','kd.bos.bd.task.BaseDataAutoUpgradeTask','31DW//PXU8I1','0',1,'BIZ','1','base_bd_autoUpgradeModelTask_SKDJ_S','1','1',0,0,' ','0','{}',0); 

DELETE FROM T_SCH_JOB_L WHERE FPKID = '31G6FU0YF0K8';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('31G6FU0UUD//','31G6FU0YF0K8','zh_CN','受控基础资料自动升级模型'); 
DELETE FROM T_SCH_JOB_L WHERE FPKID = '31G6FU0YF0K9';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('31G6FU0UUD//','31G6FU0YF0K9','zh_TW','受控基礎資料自動升級模型'); 


-- 调度计划
DELETE FROM T_SCH_SCHEDULE WHERE FID = '31G7/04245HL';
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 3 * * ?','0','172.19.108.234','0','0','0','0',{ts'2999-12-31  00:00:00'},'0','0','d','0','d','0','0','0','0','事件将于2023-02-08 00:00:00起，每1天3时重复。
预计最近十次执行时间：
2023-02-08 03:00:00,
2023-02-09 03:00:00,
2023-02-10 03:00:00,
2023-02-11 03:00:00,
2023-02-12 03:00:00,
2023-02-13 03:00:00,
2023-02-14 03:00:00,
2023-02-15 03:00:00,
2023-02-16 03:00:00,
2023-02-17 03:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','31G6FU0UUD//',{ts'2023-02-08  00:00:00'},'0','0','0','31G7/04245HL','0','0','0','0','0',' ','1','base_bd_autoUpgradeModelTask_SKDP_S','0','0',1,'0','0','0','0','0'); 

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '31G7/0424Y3W';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('31G7/04245HL','31G7/0424Y3W','zh_CN','受控基础资料自动升级模型'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '31G7/0424Y3X';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('31G7/04245HL','31G7/0424Y3X','zh_TW','受控基礎資料自動升級模型'); 


-- 调度计划分录
DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '31G7/04245HM';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('31G7/04245HL','31G6FU0UUD//','31G7/04245HM',1); 

