-- 人力编制同步组织人数
DELETE FROM T_SCH_SCHEDULE WHERE FID = '2WTFLI3NKW89';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FTWO,FSUN,FEIGHT,FNOV,FPLAN,FWED,FHOST,FTWENTYTWO,FFOUR,FMAR,FSEP,FENDTIME,FSIX,FREPEATMODE,FMAY,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSEVEN,FTWENTYSIX,FTHIRTEEN,FAUG,FDESC,FFIFTEEN,FTWENTYONE,FBYWEEK,FTUES,FSEVENTEEN,FSEVEN,FTWENTYFOUR,FMON,FTHIRTY,FTHREE,FFOURTEEN,FJAN,FNINETEEN,FTEN,FTHUR,FFRI,FJOBID,FSTARTTIME,FOCT,FAPR,FSIXTEEN,FID,FONE,FSAT,FTWENTYEIGHT,FTWENTYTHREE,FTWELVE,FNOWEEK,FSTATUS,FNUMBER,FTWENTYFIVE,FEIGHTEEN,FCYCLENUM,FTWENTYNINE,FJUL,FDEC,FJUN,FFEB) VALUES ('0','0','0','0',' ','0','0','0','0','0 0 0 * * ?','0','172.19.73.78','0','0','0','0',{ts'2199-12-31  00:00:00'},'0','d','0','0','d','0','0','0','0','事件将于2022-11-25 00:00:00起，每1天0时重复。
预计最近十次执行时间：
2022-11-25 00:00:00,
2022-11-26 00:00:00,
2022-11-27 00:00:00,
2022-11-28 00:00:00,
2022-11-29 00:00:00,
2022-11-30 00:00:00,
2022-12-01 00:00:00,
2022-12-02 00:00:00,
2022-12-03 00:00:00,
2022-12-04 00:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2WTFJI1G2IYH',{ts'2022-11-25  00:00:00'},'0','0','0','2WTFLI3NKW89','0','0','0','0','0',' ','1','homs_syncOrgEmpTask_SKDP_S','0','0',1,'0','0','0','0','0'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2WTFLI3NKUWR';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2WTFLI3NKW89','2WTFLI3NKUWR','zh_CN','同步组织人数'); 
DELETE FROM T_SCH_SCHEDULE_N WHERE FID = '2WTFLI3NKW89';
INSERT INTO T_SCH_SCHEDULE_N(FID,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('2WTFLI3NKW89',' ',' ',0,'0',0,'0','1'); 
DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '2WTFLI3NKW8=';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FJOBNUMBER,FID,FENTRYID,FSEQ) VALUES ('2WTFJI1G2IYH','2WTFLI3NKW89','2WTFLI3NKW8=',1); 


DELETE FROM T_SCH_JOB WHERE FID = '2WTFJI1G2IYH';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('2WTFJI1G2IYH','kd.hr.haos.business.task.SyncOrgEmpCountTask','2WTFAOCCK7/T','0',13466739,'BIZ','1','homs_syncOrgEmpTask_SKDJ_S','0','1',0,0,' ','0','{"enable":"1"}',0); 
DELETE FROM T_SCH_JOB_L WHERE FPKID = '2WTFJI1G2HL+';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2WTFJI1G2IYH','2WTFJI1G2HL+','zh_CN','组织人数同步'); 
DELETE FROM T_SCH_JOB_N WHERE FID = '2WTFJI1G2IYH';
INSERT INTO T_SCH_JOB_N(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION) VALUES ('2WTFJI1G2IYH',0,'0','0',0,' ','1',' ','调度作业通知'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '2WTFJI1G2IYJ';
INSERT INTO T_SCH_JOBPARAMS(FID,FMUST,FPARAMTYPE,FENTRYID,FSEQ,FBASEDATAINFO,FPARAMVALUE,FPARAMNAME) VALUES ('2WTFJI1G2IYH','1','0','2WTFJI1G2IYJ',1,' ','1','enable'); 
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '2WTFAOCCK7/T';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('2WTFAOCCK7/T','kd.hr.haos.business.task.SyncOrgEmpCountTask','homs','syncOrgEmpTask'); 
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '2WTFAOCCK5O=';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2WTFAOCCK7/T','2WTFAOCCK5O=','zh_CN','组织人数同步'); 
