/** 预置后台定时计划，自动清理BOTP删除关联关系记录日志 **/

DELETE FROM T_SCH_TASKDEFINE WHERE FID = '2CO6HKATQ1TX';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('2CO6HKATQ1TX','kd.bos.form.plugin.botp.BotpLinkLogClearTask','botp','BotpLinkLogClearTask');

DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '2CO6HKATPSCJ';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2CO6HKATQ1TX','2CO6HKATPSCJ','zh_CN','清理删除botp关联关系记录日志');
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '2CO6HKATPSCK';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2CO6HKATQ1TX','2CO6HKATPSCK','zh_TW','清理刪除botp關聯關係記錄日誌');



DELETE FROM T_SCH_JOB WHERE FID = '2CO=0WPIQSD6';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FCONCURRENT,FNUMBER,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FRUNBYORGID,FPARAMS) VALUES ('2CO=0WPIQSD6','kd.bos.form.plugin.botp.BotpLinkLogClearTask','2CO6HKATQ1TX','0',1,'BIZ','1','0','botp_BotpLinkLogClearTask_SKDJ_S','1',0,0,' ',0,'{"storageDays":"90"}');


DELETE FROM T_SCH_JOB_L WHERE FPKID = '2CO=0WPIQGYU';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2CO=0WPIQSD6','2CO=0WPIQGYU','zh_CN','清理删除关联关系记录日志');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '2CO=0WPIQGYV';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2CO=0WPIQSD6','2CO=0WPIQGYV','zh_TW','清理刪除關聯關係記錄日誌');



DELETE FROM T_SCH_SCHEDULE WHERE FID = '2COL7WF3467N';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FSUN,FTWO,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,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 0 1 * * ?','0','172.19.111.247','0','0','0','0',{ts'2999-12-31  00:00:00'},'0','d','0','0','d','0','0','0','0','事件将于2022-04-13 01:00:00起，每1天1时重复。
预计最近十次执行时间：
2022-04-13 01:00:00,
2022-04-14 01:00:00,
2022-04-15 01:00:00,
2022-04-16 01:00:00,
2022-04-17 01:00:00,
2022-04-18 01:00:00,
2022-04-19 01:00:00,
2022-04-20 01:00:00,
2022-04-21 01:00:00,
2022-04-22 01:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2CO=0WPIQSD6',{ts'2022-04-13  00:00:00'},'0','0','0','2COL7WF3467N','0','0','0','0','0',' ','1','botp_BotpLinkLogClearTask_SKDP_S','0','0',1,'0','0','0','0','0');


DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2COL7WF33WS=';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2COL7WF3467N','2COL7WF33WS=','zh_CN','清理botp删除关联关系记录日志');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2COL7WF33WSA';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2COL7WF3467N','2COL7WF33WSA','zh_TW','清理botp刪除關聯關係記錄日誌');

/**  **/


