
----生成标签脚本
DELETE FROM T_SCH_SCHEDULE WHERE FID = '2XTZOM/R81ND';
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/10 0,1,2,3,4,5,6,23 * * ?','0','172.19.100.112','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','mi','0','d','0','0','0','0','事件将于2022-12-06 23:16:48起，0时,1时,2时,3时,4时,5时,6时,23时每10分钟重复。
预计最近十次执行时间：
2022-12-06 23:20:00,
2022-12-06 23:30:00,
2022-12-06 23:40:00,
2022-12-06 23:50:00,
2022-12-07 00:00:00,
2022-12-07 00:10:00,
2022-12-07 00:20:00,
2022-12-07 00:30:00,
2022-12-07 00:40:00,
2022-12-07 00:50:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2XTZ9MO5H585',{ts'2022-12-06  00:00:00'},'0','0','0','2XTZOM/R81ND','0','0','0','0','0',' ','1','hrcs_labelGeneData','0','0',10,'0','0','0','0','0');

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2XTZOM/R9X/K';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2XTZOM/R81ND','2XTZOM/R9X/K','zh_CN','生成标签定时任务');


DELETE FROM T_SCH_JOB WHERE FID = '2XTZ9MO5H585';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('2XTZ9MO5H585','kd.hr.hrcs.bussiness.task.LabelGeneData','2XTZ40CM3HX7','0',13466739,'BIZ','1','hrcs_labelGeneData_SKDJ_S','0','1',0,0,' ','0','{}',0);

DELETE FROM T_SCH_JOB_L WHERE FPKID = '2XTZ9MO5J+LB';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2XTZ9MO5H585','2XTZ9MO5J+LB','zh_CN','标签生成定时任务');


DELETE FROM T_SCH_TASKDEFINE WHERE FID = '2XTZ40CM3HX7';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('2XTZ40CM3HX7','kd.hr.hrcs.bussiness.task.LabelGeneData','hrcs','LabelGeneData');

DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '2XTZ40CM5B9D';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2XTZ40CM3HX7','2XTZ40CM5B9D','zh_CN','LabelGeneData');



----生成标签任务脚本
 DELETE FROM T_SCH_SCHEDULE WHERE FID = '2XTAPFXZ0UD=';
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/10 * * * ?','0','172.19.100.112','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','mi','0','d','0','0','0','0','事件将于2022-12-06 18:46:15起，每10分钟重复。
预计最近十次执行时间：
2022-12-06 18:50:00,
2022-12-06 19:00:00,
2022-12-06 19:10:00,
2022-12-06 19:20:00,
2022-12-06 19:30:00,
2022-12-06 19:40:00,
2022-12-06 19:50:00,
2022-12-06 20:00:00,
2022-12-06 20:10:00,
2022-12-06 20:20:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2XTA=W1I8VQC',{ts'2022-12-06  00:00:00'},'0','0','0','2XTAPFXZ0UD=','0','0','0','0','0',' ','1','hrcs_labelGeneMarkTask','0','0',10,'0','0','0','0','0');

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2XTAPFXZ0V1J';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2XTAPFXZ0UD=','2XTAPFXZ0V1J','zh_CN','生成标签打标任务');

DELETE FROM T_SCH_JOB WHERE FID = '2XTA=W1I8VQC';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('2XTA=W1I8VQC','kd.hr.hrcs.bussiness.task.LabelGeneMarkTask','2XT=ZSR941+/','0',13466739,'BIZ','1','hrcs_labelGeneMarkTask_SKDJ_S','0','1',0,0,' ','0','{}',0);
DELETE FROM T_SCH_JOB_L WHERE FPKID = '2XTA=W1I8WDM';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2XTA=W1I8VQC','2XTA=W1I8WDM','zh_CN','生成标签的打标任务');


DELETE FROM T_SCH_TASKDEFINE WHERE FID = '2XT=ZSR941+/';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('2XT=ZSR941+/','kd.hr.hrcs.bussiness.task.LabelGeneMarkTask','hrcs','LabelGeneMarkTask');

DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '2XT=ZSR941N9';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2XT=ZSR941+/','2XT=ZSR941N9','zh_CN','LabelGeneMarkTask');

