/*调度任务类名*/
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '3J=DIMZS=LNP';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3J=DIMZS=LNP','kd.hr.haos.business.task.StructProjectUpgradeTask','haos','StructProjectUpgrade');
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '3J=DIMZS=IZO';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3J=DIMZS=LNP','3J=DIMZS=IZO','zh_CN','架构设置生效日期升级');


/*调度作业*/
DELETE FROM T_SCH_JOB WHERE FID = '3J=DN5+44I/8';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('3J=DN5+44I/8','kd.hr.haos.business.task.StructProjectUpgradeTask','3J=DIMZS=LNP','0',13466739,'BIZ','1','haos_StructProjectUpgrade_SKDJ_S','0','1',0,0,' ','0','{}',0);

DELETE FROM T_SCH_JOB_L WHERE FPKID = '3J=DN5+44FA7';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3J=DN5+44I/8','3J=DN5+44FA7','zh_CN','StructProjectUpgrade');

DELETE FROM T_SCH_JOB_N WHERE FID = '3J=DN5+44I/8';
INSERT INTO T_SCH_JOB_N(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION) VALUES ('3J=DN5+44I/8',13466739,'0','0',0,' ','1',' ','调度作业通知');


/*调度计划*/
DELETE FROM T_SCH_SCHEDULE WHERE FID = '3J=DV9+MWMA6';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FTWO,FSUN,FEIGHT,FNOV,FPLAN,FWED,FHOST,FTWENTYTWO,FFOUR,FMAR,FSEP,FENDTIME,FSIX,FREPEATMODE,FMAY,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSEVEN,FTWENTYSIX,FTHIRTEEN,FAUG,FDESC,FFIFTEEN,FTWENTYONE,FBYWEEK,FTUES,FSEVENTEEN,FSEVEN,FTWENTYFOUR,FMON,FTHIRTY,FTHREE,FFOURTEEN,FJAN,FNINETEEN,FTEN,FTHUR,FFRI,FJOBID,FSTARTTIME,FOCT,FAPR,FSIXTEEN,FID,FONE,FSAT,FTWENTYEIGHT,FTWENTYTHREE,FTWELVE,FNOWEEK,FSTATUS,FNUMBER,FTWENTYFIVE,FEIGHTEEN,FCYCLENUM,FTWENTYNINE,FJUL,FDEC,FJUN,FFEB) VALUES ('0','0','0','0',' ','0','0','0','0','0 7 * * * ?','0','172.19.106.13','0','0','0','0',{ts'2999-12-31  00:00:00'},'0','h','0','0','d','0','0','0','0','事件将于2023-09-07 20:07:27起，每1小时重复。
预计最近十次执行时间：
2023-09-07 21:07:00,
2023-09-07 22:07:00,
2023-09-07 23:07:00,
2023-09-08 00:07:00,
2023-09-08 01:07:00,
2023-09-08 02:07:00,
2023-09-08 03:07:00,
2023-09-08 04:07:00,
2023-09-08 05:07:00,
2023-09-08 06:07:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3J=DN5+44I/8',{ts'2023-09-07  00:00:00'},'0','0','0','3J=DV9+MWMA6','0','0','0','0','0',' ','1','haos_StructProjectUpgrade_SKDP_S','0','0',1,'0','0','0','0','0');

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '3J=DV9+MWJM5';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3J=DV9+MWMA6','3J=DV9+MWJM5','zh_CN','架构设置生效日期升级定时任务');

DELETE FROM T_SCH_SCHEDULE_N WHERE FID = '3J=DV9+MWMA6';
INSERT INTO T_SCH_SCHEDULE_N(FID,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('3J=DV9+MWMA6',' ',' ',0,'0',0,'0','1');

DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '3J=DV9+MWMA7';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FJOBNUMBER,FID,FENTRYID,FSEQ) VALUES ('3J=DN5+44I/8','3J=DV9+MWMA6','3J=DV9+MWMA7',1);
