-- 业务数据历史数据的推送算薪组织人字段升级任务
-- 调度任务类名
-- T_SCH_TASKDEFINE
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '3=XIU4+WO0A4';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3=XIU4+WO0A4','kd.swc.hpdi.business.task.BizDataDepempUpdateTask','hpdi','hpdi_bizdatadepempupdate_task');


-- T_SCH_TASKDEFINE_L
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '3=XIU4/+=92U';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3=XIU4+WO0A4','3=XIU4/+=92U','zh_CN','业务数据推送算薪组织人升级任务类');
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '3=XIU4/+=92V';
--INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3=XIU4+WO0A4','3=XIU4/+=92V','zh_TW','業務數據推送算薪組織人升級任務類');


-- 调度作业：hpdi_bizdatadepempupdatetask_SKDJ_S
-- T_SCH_JOB
DELETE FROM T_SCH_JOB WHERE FID = '3=XJ5LT3GZES';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FPARAMS,FRUNBYORGID) VALUES ('3=XJ5LT3GZES','kd.swc.hpdi.business.task.BizDataDepempUpdateTask','3=XIU4+WO0A4','0',1632490550739337216,'BIZ','1','hpdi_bizdatadepempupdatetask_SKDJ_S','0','1',0,0,' ','{}',0);

-- T_SCH_JOB_L
DELETE FROM T_SCH_JOB_L WHERE FPKID = '3=XJ5LT7367G';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3=XJ5LT3GZES','3=XJ5LT7367G','zh_CN','业务数据推送算薪组织人升级任务');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '3=XJ5LT7367H';
--INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3=XJ5LT3GZES','3=XJ5LT7367H','zh_TW','業務數據推送算薪組織人升級任務');


-- 调度计划：hpdi_bizdatadepempupdatetask_SKDP_S       （区块链服务云库）
-- T_SCH_SCHEDULE
DELETE FROM T_SCH_SCHEDULE WHERE FID = '3=XJH20LKJ46';
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',' ','0','0','0','0','0 */10 * * * ?','0','172.19.108.69','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','def','0','d','0','0','0','0','事件将于2023-05-25 12:00:00起，
预计最近十次执行时间：
2023-05-25 12:00:00,
2023-05-25 12:10:00,
2023-05-25 12:20:00,
2023-05-25 12:30:00,
2023-05-25 12:40:00,
2023-05-25 12:50:00,
2023-05-25 13:00:00,
2023-05-25 13:10:00,
2023-05-25 13:20:00,
2023-05-25 13:30:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3=XJ5LT3GZES',{ts'2023-05-25  00:00:00'},'0','0','0','3=XJH20LKJ46','0','0','0','0','0',' ','1','hpdi_bizdatadepempupdatetask_SKDP_S','0','0',1,'0','0','0','0','0');

-- T_SCH_SCHEDULE_L
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '3=XJH20LKBQC';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3=XJH20LKJ46','3=XJH20LKBQC','zh_CN','业务数据推送算薪组织人升级任务');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '3=XJH20LKBQD';
--INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3=XJH20LKJ46','3=XJH20LKBQD','zh_TW','業務數據推送算薪組織人升級任務');

-- T_SCH_SCHEDULE_ENTRY
DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '3=XJH20LKJ47';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3=XJH20LKJ46','3=XJ5LT3GZES','3=XJH20LKJ47',1);
