
-- 调度任务类名
DELETE FROM t_sch_taskdefine WHERE FID = '3EU33=A+VSC+';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3EU33=A+VSC+','kd.hr.hdm.business.schedule.BatchPartTimeQuitTask','hdm','BatchPartTimeQuitTask'); 

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '3EU33=A+XJ04';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3EU33=A+VSC+','3EU33=A+XJ04','zh_CN','批量兼职大单处理');



-- 调度作业
DELETE FROM T_SCH_JOB WHERE FID = '3EU6/W9+QBYN';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('3EU6/W9+QBYN','kd.hr.hdm.business.schedule.BatchPartTimeQuitTask','3EU33=A+VSC+','0',13466739,'BIZ','1','hdm_batchpartquit_task_SKDJ_S','0','1',0,0,' ','0','{}',0);


DELETE FROM T_SCH_JOB_l WHERE FPKID = '3EU6/W9+OHX7';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3EU6/W9+QBYN','3EU6/W9+OHX7','zh_CN','批量兼职大单状态更新定时任务');


-- 调度计划
DELETE FROM t_sch_schedule WHERE FID = '3EU6ADJFXZYE';
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 24 0 * * ?','0','172.19.77.143','0','0','0','0',{ts'2099-12-30  00:00:00'},'0','0','d','0','d','0','0','0','0','事件将于2023-07-19 15:24:49起，每1天0时重复。
预计最近十次执行时间：
2023-07-20 00:24:00,
2023-07-21 00:24:00,
2023-07-22 00:24:00,
2023-07-23 00:24:00,
2023-07-24 00:24:00,
2023-07-25 00:24:00,
2023-07-26 00:24:00,
2023-07-27 00:24:00,
2023-07-28 00:24:00,
2023-07-29 00:24:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3EU6/W9+QBYN',{ts'2023-07-19  00:00:00'},'0','0','0','3EU6ADJFXZYE','0','0','0','0','0',' ','1','hdm_batchpartquit_plan_SKDP_S','0','0',1,'0','0','0','0','0'); 


DELETE FROM t_sch_schedule_l WHERE FPKID = '3EU6ADJFZTZV';
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3EU6ADJFXZYE','3EU6ADJFZTZV','zh_CN','批量兼职大单状态更新计划');


DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '3EU6ADJFXZYF';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3EU6ADJFXZYE','3EU6/W9+QBYN','3EU6ADJFXZYF',1);


-- 拆分表
DELETE FROM t_sch_schedule_n WHERE FID = '3EU6ADJFXZYE';
INSERT INTO t_sch_schedule_n(FID,FSNOTIFYTYPE,FMSGRECEIVER,FSMSGCONTENT,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('3EU6ADJFXZYE',' ',0,' ','0',0,'0','1'); 
 

