/* 增加定期清理组织和人员历史的任务 */
DELETE FROM t_sch_taskdefine WHERE fid = '1LL1SKLZ8APG';
INSERT INTO t_sch_taskdefine(fid,fclassname,fappid,fnumber) VALUES ('1LL1SKLZ8APG','kd.bos.org.task.OrgHistoryClearTask','base','OrgHistoryClearTask');
DELETE FROM t_sch_taskdefine WHERE fid = '1LLB4NR38ICR';
INSERT INTO t_sch_taskdefine(fid,fclassname,fappid,fnumber) VALUES ('1LLB4NR38ICR','kd.bos.sec.user.task.UserHistoryClearTask','base','UserHistoryClearTask');

DELETE FROM t_sch_taskdefine_l WHERE fpkid = '1LL1SKLZ8M4U';
INSERT INTO t_sch_taskdefine_l(fid,fpkid,flocaleid,fname) VALUES ('1LL1SKLZ8APG','1LL1SKLZ8M4U','zh_CN','组织历史记录清理任务');
DELETE FROM t_sch_taskdefine_l WHERE fpkid = '1LLB4NR6VXX/';
INSERT INTO t_sch_taskdefine_l(fid,fpkid,flocaleid,fname) VALUES ('1LLB4NR38ICR','1LLB4NR6VXX/','zh_CN','人员历史记录清理任务');

DELETE FROM T_SCH_JOB WHERE fid = '1LL1U5FFL93H';
INSERT INTO T_SCH_JOB(fid,ftaskclassname,ftaskdefineid,frunmode,frunbyuserid,fjobtype,fstatus,fconcurrent,fnumber,fstrategy,ftimeout,fretrytime,frunbylang,frunbyorgid,fparams) VALUES ('1LL1U5FFL93H','kd.bos.org.task.OrgHistoryClearTask','1LL1SKLZ8APG','0', 1,'BIZ','1','0','base_org_history_claar_job_SKDJ_S','1',0,0,' ',0,'{"storageDays":"30"}');
DELETE FROM T_SCH_JOB WHERE fid = '1LLB6UVSO2G/';
INSERT INTO T_SCH_JOB(fid,ftaskclassname,ftaskdefineid,frunmode,frunbyuserid,fjobtype,fstatus,fconcurrent,fnumber,fstrategy,ftimeout,fretrytime,frunbylang,frunbyorgid,fparams) VALUES ('1LLB6UVSO2G/','kd.bos.sec.user.task.UserHistoryClearTask','1LLB4NR38ICR','0', 1,'BIZ','1','0','base_user_history_claar_job_SKDJ_S','1',0,0,' ',0,'{"storageDays":"30"}');

DELETE FROM T_SCH_JOB_l WHERE fpkid = '1LL1U5FJ7ZRC';
INSERT INTO T_SCH_JOB_l(fid,fpkid,flocaleid,fname) VALUES ('1LL1U5FFL93H','1LL1U5FJ7ZRC','zh_CN','组织历史数据清理作业');
DELETE FROM T_SCH_JOB_l WHERE fpkid = '1LLB6UVW=H+9';
INSERT INTO T_SCH_JOB_l(fid,fpkid,flocaleid,fname) VALUES ('1LLB6UVSO2G/','1LLB6UVW=H+9','zh_CN','人员历史数据清理作业');

DELETE FROM t_sch_schedule WHERE fid = '1LL1W=K7DWS/';
INSERT INTO t_sch_schedule(ftwenty,ffive,feleven,fno,fnine,fsun,ftwo,feight,fnov,fplan,fwed,fhost,ftwentytwo,ffour,fmar,fsep,fsix,fendtime,fmay,frepeatmode,fthirtyone,fbydayorweek,ftwentyseven,fthirteen,ftwentysix,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,ftwentynine,fcyclenum,fjul,fdec,fjun,ffeb) VALUES ('0','0','0',' ','0','0','0','0','0','0 0 1 * * ?','0',' ','0','0','0','0','0',{ts'2999-12-31  00:00:00'},'0','d','0','d','0','0','0','0','事件将于2021-05-10 01:00:00起，
每1天重复。
预计最近十次执行时间：
2021-05-10 01:00:00,
2021-05-11 01:00:00,
2021-05-12 01:00:00,
2021-05-13 01:00:00,
2021-05-14 01:00:00,
2021-05-15 01:00:00,
2021-05-16 01:00:00,
2021-05-17 01:00:00,
2021-05-18 01:00:00,
2021-05-19 01:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1LL1U5FFL93H',{ts'2021-05-01  00:00:00'},'0','0','0','1LL1W=K7DWS/','0','0','0','0','0',' ','1','base_org_history_clear_plan','0','0','0',1,'0','0','0','0');
DELETE FROM t_sch_schedule WHERE fid = '1LNXFF4A4L+T';
INSERT INTO t_sch_schedule(ftwenty,ffive,feleven,fno,fnine,fsun,ftwo,feight,fnov,fplan,fwed,fhost,ftwentytwo,ffour,fmar,fsep,fsix,fendtime,fmay,frepeatmode,fthirtyone,fbydayorweek,ftwentyseven,fthirteen,ftwentysix,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,ftwentynine,fcyclenum,fjul,fdec,fjun,ffeb) VALUES ('0','0','0',' ','0','0','0','0','0','0 0 1 * * ?','0',' ','0','0','0','0','0',{ts'2999-12-31  00:00:00'},'0','d','0','d','0','0','0','0','事件将于2021-05-01 01:00:00起，
每1天重复。
预计最近十次执行时间：
2021-05-01 01:00:00,
2021-05-02 01:00:00,
2021-05-03 01:00:00,
2021-05-04 01:00:00,
2021-05-05 01:00:00,
2021-05-06 01:00:00,
2021-05-07 01:00:00,
2021-05-08 01:00:00,
2021-05-09 01:00:00,
2021-05-10 01:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1LLB6UVSO2G/',{ts'2021-05-01  00:00:00'},'0','0','0','1LNXFF4A4L+T','0','0','0','0','0',' ','1','base_user_history_clear_plan','0','0','0',1,'0','0','0','0');

DELETE FROM t_sch_schedule_l WHERE fpkid = '1LL1W=K7E67C';
INSERT INTO t_sch_schedule_l(fid,fpkid,flocaleid,fname) VALUES ('1LL1W=K7DWS/','1LL1W=K7E67C','zh_CN','组织历史记录清理任务执行计划');
DELETE FROM t_sch_schedule_l WHERE fpkid = '1LNXFF4A4KAJ';
INSERT INTO t_sch_schedule_l(fid,fpkid,flocaleid,fname) VALUES ('1LNXFF4A4L+T','1LNXFF4A4KAJ','zh_CN','人员历史记录清理任务执行计划');

DELETE FROM t_sch_schedule_entry WHERE fentryid = '1LL1W=K7DWS0';
INSERT INTO t_sch_schedule_entry(fid,fjobnumber,fentryid,fseq) VALUES ('1LL1W=K7DWS/','1LL1U5FFL93H','1LL1W=K7DWS0',1);
DELETE FROM t_sch_schedule_entry WHERE fentryid = '1LNXFF4A4L+U';
INSERT INTO t_sch_schedule_entry(fid,fjobnumber,fentryid,fseq) VALUES ('1LNXFF4A4L+T','1LLB6UVSO2G/','1LNXFF4A4L+U',1);

DELETE FROM T_SCH_JOBPARAMS WHERE fid = '1LL1U5FFL93H';
INSERT INTO T_SCH_JOBPARAMS(fid,fentryid,fseq,fparamvalue,fparamname) VALUES ('1LL1U5FFL93H','1LL1U5FJ7OA/',1,'30','storageDays');
DELETE FROM T_SCH_JOBPARAMS WHERE fid = '1LLB6UVSO2G/';
INSERT INTO T_SCH_JOBPARAMS(fid,fentryid,fseq,fparamvalue,fparamname) VALUES ('1LLB6UVSO2G/','1LLB6UVW=HNI',1,'30','storageDays');



