-- 调度程序
DELETE FROM t_sch_taskdefine WHERE FID = '3W/QJBMDVIYM';
INSERT INTO t_sch_taskdefine(FID,FCREATETIME,FMODIFIERID,FRESCHEDULED,FMODIFYTIME,FCLASSNAME,FAPPID,FCREATORID,FNUMBER) VALUES ('3W/QJBMDVIYM',{ts'2024-01-28  00:00:00'},1,'0',{ts'2024-01-28  00:00:00'},'kd.swc.hpdi.business.task.UpdateCollaRuleAndFieldRuleTask','hpdi',1,'hpdi_updatecollaruleandfieldruletask_task'); 
DELETE FROM t_sch_taskdefine_L WHERE FPKID = '3W/QJBMDVI9C';
INSERT INTO t_sch_taskdefine_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3W/QJBMDVIYM','3W/QJBMDVI9C','zh_CN','HPDI升级协作规则与字段规则任务'); 


-- 调度作业
DELETE FROM T_SCH_JOB WHERE FID = '3W/QNGOILX7+';
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 ('3W/QNGOILX7+','kd.swc.hpdi.business.task.UpdateCollaRuleAndFieldRuleTask','0','3W/QJBMDVIYM',1,'BIZ','0','1','hpdi_UpdateCollaRuleAndFieldRuleTask_SKDJ_S','0','1',{ts'2024-01-28  00:00:00'},1,0,0,{ts'2024-01-28  00:00:00'},' ','0',1,'{}',0); 
DELETE FROM T_SCH_JOB_n WHERE FID = '3W/QNGOILX7+';
INSERT INTO T_SCH_JOB_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION,FABORTED) VALUES ('3W/QNGOILX7+',0,'0','0',0,' ','1',' ','调度作业通知','0'); 
DELETE FROM T_SCH_JOB_L WHERE FPKID = '3W/QNGOILXW8';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3W/QNGOILX7+','3W/QNGOILXW8','zh_CN','HPDI升级薪资协作规则与字段规则'); 


-- 调度计划

DELETE FROM T_SCH_SCHEDULE WHERE FID = '3W/QQ04J8=VO';
INSERT INTO T_SCH_SCHEDULE(FID,FSTATUS,FDESC,FNUMBER,FPLAN,FHOST,FCREATETIME,FCYCLENUM,FMODIFIERID,FSTARTTIME,FMODIFYTIME,FJOBID,FENDTIME,FCREATORID,FREPEATMODE) VALUES ('3W/QQ04J8=VO','1','事件将于2024-01-28 18:43:09起，每5分钟重复。
预计最近10次执行时间：
2024-01-31 10:30:00,
2024-01-31 10:35:00,
2024-01-31 10:40:00,
2024-01-31 10:45:00,
2024-01-31 10:50:00,
2024-01-31 10:55:00,
2024-01-31 11:00:00,
2024-01-31 11:05:00,
2024-01-31 11:10:00,
2024-01-31 11:15:00','hpdi_UpdateCollaRuleAndFieldRuleTask_SKDP_S','0 0/5 * * * ?','172.19.75.93',{ts'2024-01-28  00:00:00'},5,1,{ts'2024-01-28  00:00:00'},{ts'2024-01-31  00:00:00'},'3W/QNGOILX7+',{ts'2099-12-31  00:00:00'},1,'mi'); 
DELETE FROM T_SCH_SCHEDULE_n WHERE FID = '3W/QQ04J8=VO';
INSERT INTO T_SCH_SCHEDULE_n(FID,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY,FSABORTED) VALUES ('3W/QQ04J8=VO',' ',' ',0,'0',0,'0','1','0'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '3W/QQ04J8=6F';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3W/QQ04J8=VO','3W/QQ04J8=6F','zh_CN','HPDI升级薪资协作规则与字段规则'); 
DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '3W/QQ04J8=VP';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3W/QQ04J8=VO','3W/QNGOILX7+','3W/QQ04J8=VP',1); 
DELETE FROM t_sch_schedule_m WHERE FENTRYID = '3W/QZIITR07/';
INSERT INTO t_sch_schedule_m(FID,FMSGTYPE,FSNOTIFYTYPE,FSMSGCONTENT,FENTRYID,FSEQ) VALUES ('3W/QQ04J8=VO','FAILED,',' ',' ','3W/QZIITR07/',1); 