-- 调度作业表
DELETE FROM T_SCH_JOB WHERE FID = '2IDFFYDXK4O0';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('2IDFFYDXK4O0','kd.hr.hrcs.bussiness.task.RetainedDuePersonTask','2=JGPWK+M3E6','0',13466739,'BIZ','1','hrcs_RetainedDueCAND_SKDJ_S','0','1',0,0,' ','0','{"dataRoleNumber":"1020_S"}',0);

-- 调度作业多语言表
DELETE FROM T_SCH_JOB_l WHERE FPKID = '2IDFFYDXK4+S';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2IDFFYDXK4O0','2IDFFYDXK4+S','zh_CN','候选人留存到期调度作业');


-- 调度计划表
DELETE FROM T_SCH_SCHEDULE WHERE FID = '2IDFHY646GK0';
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 43 0 * * ?','0','172.19.110.185','0','0','0','0',{ts'2154-07-16  00:00:00'},'0','0','d','0','d','0','0','0','0','事件将于2022-06-16 17:43:34起，每1天0时重复。
预计最近十次执行时间：
2022-06-17 00:43:00,
2022-06-18 00:43:00,
2022-06-19 00:43:00,
2022-06-20 00:43:00,
2022-06-21 00:43:00,
2022-06-22 00:43:00,
2022-06-23 00:43:00,
2022-06-24 00:43:00,
2022-06-25 00:43:00,
2022-06-26 00:43:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2IDFFYDXK4O0',{ts'2022-06-16  00:00:00'},'0','0','0','2IDFHY646GK0','0','0','0','0','0',' ','1','hrcs_RetainedDueCAND_SKDP_S','0','0',1,'0','0','0','0','0');

-- 调度计划多语言表
DELETE FROM t_sch_schedule_l WHERE FPKID = '2IDFHY67TXET';
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2IDFHY646GK0','2IDFHY67TXET','zh_CN','候选人留存到期调度计划');


-- 调度计划分录表
DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '2IDFHY67TWRJ';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('2IDFHY646GK0','2IDFFYDXK4O0','2IDFHY67TWRJ',1);