--调度任务类名
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '33EO1AIK8KK=';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('33EO1AIK8KK=','kd.hr.haos.business.task.AdminOrgSortCodeUpgradeTask','haos','AdminOrgSortCodeUpgradeTask');
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '33EO1AIK8L8J';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('33EO1AIK8KK=','33EO1AIK8L8J','zh_CN','组织排序结构历史数据升级任务');
--调度作业
DELETE FROM T_SCH_JOB WHERE FID = '33EOS212RQHI';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('33EOS212RQHI','kd.hr.haos.business.task.AdminOrgSortCodeUpgradeTask','33EO1AIK8KK=','0',1,'BIZ','1','haos_adminSortcodeUpgradeTask_SKDJ_S','0','1',0,0,'zh_CN','0','{}',0);
DELETE FROM T_SCH_JOB_L WHERE FPKID = '33EOS21G9DYU';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('33EOS212RQHI','33EOS21G9DYU','zh_CN','行政组织排序结构历史数据升级');
DELETE FROM T_SCH_JOB_N WHERE FID = '33EOS212RQHI';
INSERT INTO T_SCH_JOB_N(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION) VALUES ('33EOS212RQHI',0,'0','0',0,' ','1',' ','调度作业通知');
--调度计划
DELETE FROM T_SCH_SCHEDULE WHERE FID = '33EOXK85LRBB';
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/15 * * * ?','0','172.19.79.131','0','0','0','0',{ts'2999-12-31 00:00:00'},'0','def','0','0','d','0','0','0','0','事件将于2023-03-02 09:58:33起，
预计最近十次执行时间：
2023-03-02 10:00:00,
2023-03-02 10:15:00,
2023-03-02 10:30:00,
2023-03-02 10:45:00,
2023-03-02 11:00:00,
2023-03-02 11:15:00,
2023-03-02 11:30:00,
2023-03-02 11:45:00,
2023-03-02 12:00:00,
2023-03-02 12:15:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','33EOS212RQHI',{ts'2023-03-02  00:00:00'},'0','0','0','33EOXK85LRBB','0','0','0','0','0',' ','1','haos_adminSortcodeUpgradeTask_SKDP_S','0','0',1,'0','0','0','0','0');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '33EOXK85LS/L';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('33EOXK85LRBB','33EOXK85LS/L','zh_CN','行政组织排序结构历史数据升级');
DELETE FROM T_SCH_SCHEDULE_N WHERE FID = '33EOXK85LRBB';
INSERT INTO T_SCH_SCHEDULE_N(FID,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('33EOXK85LRBB',' ',' ',0,'0',0,'0','1');
DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '33EOXK85LRBC';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FJOBNUMBER,FID,FENTRYID,FSEQ) VALUES ('33EOS212RQHI','33EOXK85LRBB','33EOXK85LRBC',1);
