/* 调度任务类名-业务数据已撤回状态同步更新失效日期类型业务数据 */
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '3XW7+A3GEDQJ';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3XW7+A3GEDQJ','kd.swc.hpdi.business.task.BizDataRollbackStatusTask','hpdi','hpdi_BizDataRollbackStatusTask');

DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '3XW7+A3GE7AQ';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3XW7+A3GEDQJ','3XW7+A3GE7AQ','zh_CN','业务数据已撤回/算薪驳回状态同步更新失效日期类型业务数据');

/* 调度作业-业务数据已撤回状态同步更新失效日期类型业务数据 */
DELETE FROM T_SCH_JOB WHERE FID = '3XW7XGDA8IZN';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FPARAMS,FRUNBYORGID) VALUES ('3XW7XGDA8IZN','kd.swc.hpdi.business.task.BizDataRollbackStatusTask','3XW7+A3GEDQJ','0',1,'BIZ','1','hpdi_BizDataRollbackStatusTask_SKDJ_S','0','1',0,0,' ','{}',0);

DELETE FROM T_SCH_JOB_L WHERE FPKID = '3XW7XGDA8JMX';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3XW7XGDA8IZN','3XW7XGDA8JMX','zh_CN','业务数据已撤回/算薪驳回状态同步更新失效日期类型业务数据');

/* 调度计划-业务数据已撤回状态同步更新失效日期类型业务数据 */
DELETE FROM T_SCH_SCHEDULE WHERE FID = '3Y4JAQHZ21W=';
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 1 * * ?','0','172.19.109.132','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','d','0',NULL,'0','0','0','0','事件将于2024-02-21 15:00:00起，每1天1时重复。
预计最近10次执行时间：
2024-02-22 01:00:00,
2024-02-23 01:00:00,
2024-02-24 01:00:00,
2024-02-25 01:00:00,
2024-02-26 01:00:00,
2024-02-27 01:00:00,
2024-02-28 01:00:00,
2024-02-29 01:00:00,
2024-03-01 01:00:00,
2024-03-02 01:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3XW7XGDA8IZN',{ts'2024-02-21  00:00:00'},'0','0','0','3Y4JAQHZ21W=','0','0','0','0','0',NULL,'1','hpdi_BizDataRollbackStatusTask_SKDP_S','0','0',1,'0','0','0','0','0');

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '3Y4JAQHZ1WGH';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Y4JAQHZ21W=','3Y4JAQHZ1WGH','zh_CN','业务数据已撤回/算薪驳回状态同步更新失效日期类型业务数据');

DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '3Y4JAQHZ21WA';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3Y4JAQHZ21W=','3XW7XGDA8IZN','3Y4JAQHZ21WA',1);



/* 调度任务类名-业务数据失效日期更新记录同步算薪侧 */
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '3Y4MPASI520G';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3Y4MPASI520G','kd.swc.hpdi.business.task.BizDataOperateHisSyncTask','hpdi','hpdi_BizDataOperateHisSyncTask');

DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '3Y4MPASLS=U5';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Y4MPASI520G','3Y4MPASLS=U5','zh_CN','业务数据失效日期更新记录同步算薪侧');

/* 调度作业-业务数据失效日期更新记录同步算薪侧 */
DELETE FROM T_SCH_JOB WHERE FID = '3Y4MZ+0W6V0F';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FPARAMS,FRUNBYORGID) VALUES ('3Y4MZ+0W6V0F','kd.swc.hpdi.business.task.BizDataOperateHisSyncTask','3Y4MPASI520G','0',1,'BIZ','1','hpdi_BizDataOperateHisSyncTask_SKDJ_S','0','1',0,0,' ','{}',0);

DELETE FROM T_SCH_JOB_L WHERE FPKID = '3Y4MZ+0W6NMM';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Y4MZ+0W6V0F','3Y4MZ+0W6NMM','zh_CN','业务数据失效日期更新记录同步算薪侧');

/* 调度计划-业务数据失效日期更新记录同步算薪侧 */
DELETE FROM T_SCH_SCHEDULE WHERE FID = '3Y4P7=EUEU34';
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 2 * * ?','0','172.19.109.132','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','d','0',NULL,'0','0','0','0','事件将于2024-02-21 16:00:00起，每1天2时重复。
预计最近10次执行时间：
2024-02-22 02:00:00,
2024-02-23 02:00:00,
2024-02-24 02:00:00,
2024-02-25 02:00:00,
2024-02-26 02:00:00,
2024-02-27 02:00:00,
2024-02-28 02:00:00,
2024-02-29 02:00:00,
2024-03-01 02:00:00,
2024-03-02 02:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3Y4MZ+0W6V0F',{ts'2024-02-21  00:00:00'},'0','0','0','3Y4P7=EUEU34','0','0','0','0','0',NULL,'1','hpdi_BizDataOperateHisSyncTask_SKDP_S','0','0',1,'0','0','0','0','0');

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '3Y4P7=EUEMPB';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3Y4P7=EUEU34','3Y4P7=EUEMPB','zh_CN','业务数据失效日期更新记录同步算薪侧');

DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '3Y4P7=EUEU35';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3Y4P7=EUEU34','3Y4MZ+0W6V0F','3Y4P7=EUEU35',1);