-- 元数据日志清理
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '0RYE0T3OVAO=';
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '0RYE0T3OV07Y';
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '0RYE0T3OV07Z';
INSERT INTO T_SCH_TASKDEFINE(FID, FCLASSNAME, FNUMBER, FAPPID) VALUES ('0RYE0T3OVAO=', 'kd.bos.service.metadata.log.MetadataLogCleanTask', 'MetadataLogCleanTask', 'bos');
INSERT INTO T_SCH_TASKDEFINE_L(FPKID, FID, FLOCALEID, FNAME) VALUES ('0RYE0T3OV07Y', '0RYE0T3OVAO=', 'zh_CN', '元数据日志清理任务');
INSERT INTO T_SCH_TASKDEFINE_L(FPKID, FID, FLOCALEID, FNAME) VALUES ('0RYE0T3OV07Z', '0RYE0T3OVAO=', 'zh_TW', '元數據日誌清理任務');

DELETE FROM T_SCH_JOB WHERE FID = '0RYE5736KT0P';
DELETE FROM T_SCH_JOB_L WHERE FPKID = '0RYE573=6XSV';
DELETE FROM T_SCH_JOB_L WHERE FPKID = '0RYE573=6XSW';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FTIMEOUT,FRUNBYLANG,FSTATUS,FPARAMS,FRUNBYORGID,FNUMBER) VALUES ('0RYE5736KT0P','kd.bos.service.metadata.log.MetadataLogCleanTask','0RYE0T3OVAO=',13466739,'BIZ',0,' ','1',' ',0,'bos_MetadataLogCleanJob_SKDJ_S'); 
INSERT INTO T_SCH_JOB_L(FPKID, FID, FLOCALEID, FNAME) VALUES ('0RYE573=6XSV', '0RYE5736KT0P', 'zh_CN', '元数据日志清理作业');
INSERT INTO T_SCH_JOB_L(FPKID, FID, FLOCALEID, FNAME) VALUES ('0RYE573=6XSW', '0RYE5736KT0P', 'zh_TW', '元數據日誌清理作業');


DELETE FROM T_SCH_SCHEDULE WHERE FID = '0RYE8H+V/+/Z';
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '0RYE8H+V+OKL';
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '0RYE8H+V+OKM';
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 8 6 ? * 7','0','10.10.169.162','0','0','0','0',{ts'2049-05-08  19:08:43'},'0','0','w','0','d','0','0','0','0','事件将于2020-05-08 19:08:43起，
每1周的星期六6时重复。
预计下一次执行时间：2020-05-09 06:08:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0RYE5736KT0P',{ts'2020-05-08  19:08:43'},'0','0','0','0RYE8H+V/+/Z','1','0','0','0','0',' ','1','bos_MetadataLogCleanPlan_SKDP_S','0','0',1,'0','0','0','0','0');
INSERT INTO T_SCH_SCHEDULE_L(FPKID, FID, FLOCALEID, FNAME) VALUES ('0RYE8H+V+OKL', '0RYE8H+V/+/Z', 'zh_CN', '元数据日志清理计划');
INSERT INTO T_SCH_SCHEDULE_L(FPKID, FID, FLOCALEID, FNAME) VALUES ('0RYE8H+V+OKM', '0RYE8H+V/+/Z', 'zh_TW', '元數據日誌清理計劃');





