/*法定合并-清理采集日志-系统调度预置*/

/*调度任务类名*/
DELETE FROM t_sch_taskdefine WHERE FID = '17TRYT4S9XX9';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('17TRYT4S9XX9','kd.fi.bcm.business.datacollet.DatacollectLogCleanTask','cm','bcm_CleanLogTask'); 

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '17TRYT4S9YKI';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('17TRYT4S9XX9','17TRYT4S9YKI','zh_CN','清理采集日志'); 

/*调度作业*/
DELETE FROM T_SCH_JOB WHERE FID = '17TTV38YPV=N';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FPARAMS,FNUMBER) VALUES ('17TTV38YPV=N','kd.fi.bcm.business.datacollet.DatacollectLogCleanTask','17TRYT4S9XX9',1,'BIZ','1',' ','cm_bcm_CleanLogJob_SKDJ_S'); 

DELETE FROM T_SCH_JOB_l WHERE FPKID = '17TTV38YPVZX';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('17TTV38YPV=N','17TTV38YPVZX','zh_CN','清理采集日志'); 

-- 调度计划
DELETE FROM T_SCH_SCHEDULE WHERE FID = '17TV3JFJ21/A';
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',' ','1','0','0','0','0 0 0 ? * 1','0','172.19.106.119','0','0','0','0',{ts'2099-01-01  00:00:00'},'0','0','w','0','d','0','0','0','0','事件将于2020-11-01 00:00:00起，
每1周的星期日0时重复。
预计最近十次执行时间：
2020-11-01 00:00:00,
2020-11-08 00:00:00,
2020-11-15 00:00:00,
2020-11-22 00:00:00,
2020-11-29 00:00:00,
2020-12-06 00:00:00,
2020-12-13 00:00:00,
2020-12-20 00:00:00,
2020-12-27 00:00:00,
2021-01-03 00:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','17TTV38YPV=N',{ts'2020-11-01  00:00:00'},'0','0','0','17TV3JFJ21/A','0','0','0','0','0',' ','1','cm_bcm_CleanLog_SKDP_S','0','0',1,'0','0','0','0','0'); 

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '17TV3JFJ20B1';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('17TV3JFJ21/A','17TV3JFJ20B1','zh_CN','清理采集日志'); 
