-- 调度程序
DELETE FROM t_sch_taskdefine WHERE FID = '49ZML2V5PK37';
INSERT INTO t_sch_taskdefine(FID,FCREATETIME,FMODIFIERID,FRESCHEDULED,FMODIFYTIME,FCLASSNAME,FAPPID,FCREATORID,FNUMBER) VALUES ('49ZML2V5PK37',{ts'2024-07-25  00:00:00'},13466739,'0',{ts'2024-07-25  00:00:00'},'kd.swc.hpdi.business.task.TaskRuleVerConfUpdateTask','hpdi',13466739,'hpdi_TaskRuleVerConfUpdateTask');

DELETE FROM t_sch_taskdefine_L WHERE FPKID = '49ZML2V5RMX+';
INSERT INTO t_sch_taskdefine_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('49ZML2V5PK37','49ZML2V5RMX+','zh_CN','协作任务编排核定单设置旧数据升级');


-- 调度作业
DELETE FROM T_SCH_JOB WHERE FID = '49ZN7YT2884I';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FRUNMODE,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FTASKTRACE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FCREATETIME,FMODIFIERID,FTIMEOUT,FRETRYTIME,FMODIFYTIME,FRUNBYLANG,FCANSTOP,FCREATORID,FPARAMS,FRUNBYORGID) VALUES ('49ZN7YT2884I','kd.swc.hpdi.business.task.TaskRuleVerConfUpdateTask','0','49ZML2V5PK37',1158705950345960448,'BIZ','0','1','hpdi_TaskRuleVerConfUpdateTask_SKDJ_S','0','1',{ts'2024-07-25  00:00:00'},13466739,0,0,{ts'2024-07-25  00:00:00'},' ','0',13466739,'{}',0);

DELETE FROM T_SCH_JOB_n WHERE FID = '49ZN7YT2884I';
INSERT INTO T_SCH_JOB_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION,FABORTED) VALUES ('49ZN7YT2884I',1158705950345960448,'0','0',0,' ','1',' ','调度作业通知','0');

DELETE FROM T_SCH_JOB_L WHERE FPKID = '49ZN7YT287G9';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('49ZN7YT2884I','49ZN7YT287G9','zh_CN','协作任务编排核定单设置旧数据升级');


-- 调度计划
DELETE FROM T_SCH_SCHEDULE WHERE FID = '49ZNC8=L/GMW';
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,FFEB,FJUN) VALUES ('0','0','0','0',NULL,'0','0','0','0','0 0/10 * * * ?','0','172.19.109.61','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','mi','0',NULL,'0','0','0','0','事件将于2024-07-25 00:00:00起，每10分钟重复。
预计最近10次执行时间：
2024-08-30 15:20:00,
2024-08-30 15:30:00,
2024-08-30 15:40:00,
2024-08-30 15:50:00,
2024-08-30 16:00:00,
2024-08-30 16:10:00,
2024-08-30 16:20:00,
2024-08-30 16:30:00,
2024-08-30 16:40:00,
2024-08-30 16:50:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','49ZN7YT2884I',{ts'2024-07-25  00:00:00'},'0','0','0','49ZNC8=L/GMW','0','0','0','0','0',NULL,'1','hpdi_TaskRuleVerConfUpdateTask_SKDP_S','0','0',10,'0','0','0','0','0');

DELETE FROM T_SCH_SCHEDULE_n WHERE FID = '49ZNC8=L/GMW';
INSERT INTO T_SCH_SCHEDULE_n(FID,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY,FSABORTED) VALUES ('49ZNC8=L/GMW',' ',' ',0,'0',0,'0','0','0');

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '49ZNC8=L/HA5';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('49ZNC8=L/GMW','49ZNC8=L/HA5','zh_CN','协作任务编排核定单设置旧数据升级');

DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '49ZNC8=L/GMX';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('49ZNC8=L/GMW','49ZN7YT2884I','49ZNC8=L/GMX',1);
