/*体系功能权限日志-清理体系功能权限日志-系统调度预置*/

/*调度任务类名*/
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '2B3=VDJI9WPZ';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('2B3=VDJI9WPZ','kd.fi.bcm.task.PermLogAutoCleanPlugin','cm','bcm_CleanPermLogTask');

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '2B3=VDJI9FWJ';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2B3=VDJI9WPZ','2B3=VDJI9FWJ','zh_CN','清理权限日志');

/*调度作业*/
DELETE FROM T_SCH_JOB WHERE FID = '2B3BD572HKLT';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FTASKDEFINEID,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('2B3BD572HKLT','kd.fi.bcm.task.PermLogAutoCleanPlugin','0',13466739,'BIZ','1','cm_bcm_CleanPermLogJob_SKDJ_S','1','1',0,'2B3=VDJI9WPZ',0,'zh_CN','0','{}',0);

DELETE FROM t_sch_job_l WHERE FPKID = '2B3BD572J67N';
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2B3BD572HKLT','2B3BD572J67N','zh_CN','清理权限日志作业');

/*调度计划*/
DELETE FROM t_sch_schedule WHERE FID = '2B3BKM1M+ZE+';
INSERT INTO t_sch_schedule(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FSUN,FTWO,FFIFTEEN,FDESC,FEIGHT,FNOV,FPLAN,FWED,FHOST,FFOUR,FMAR,FENDTIME,FSIX,FMAY,FREPEATMODE,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSIX,FTHIRTEEN,FAUG,FTWENTYONE,FBYWEEK,FTUES,FSEVENTEEN,FTWENTYFOUR,FTHIRTY,FTHREE,FFOURTEEN,FJAN,FSEVEN,FNINETEEN,FTHUR,FTEN,FFRI,FJOBID,FSTARTTIME,FOCT,FMON,FAPR,FSIXTEEN,FID,FSAT,FONE,FTWENTYEIGHT,FTWENTYTHREE,FTWELVE,FNOWEEK,FSTATUS,FNUMBER,FTWENTYTWO,FSEP,FTWENTYFIVE,FEIGHTEEN,FCYCLENUM,FTWENTYNINE,FJUL,FTWENTYSEVEN,FDEC,FJUN,FFEB) VALUES ('0','0','0','0',' ','1','0','0','事件将于2022-03-30 00:00:00起，
每1周的星期日0时重复。
预计最近十次执行时间：
2022-04-03 00:00:00,
2022-04-10 00:00:00,
2022-04-17 00:00:00,
2022-04-24 00:00:00,
2022-05-01 00:00:00,
2022-05-08 00:00:00,
2022-05-15 00:00:00,
2022-05-22 00:00:00,
2022-05-29 00:00:00,
2022-06-05 00:00:00','0','0','0 0 0 ? * 1','0','172.19.105.133','0','0',{ts'2060-06-06  00:00:00'},'0','0','w','0','d','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2B3BD572HKLT',{ts'2022-03-30  00:00:00'},'0','0','0','0','2B3BKM1M+ZE+','0','0','0','0','0',' ','1','cm_bcm_CleanPermLog_SKDP_S','0','0','0','0',1,'0','0','0','0','0','0');

DELETE FROM t_sch_schedule_l WHERE FPKID = '2B3BKM1M0K/U';
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2B3BKM1M+ZE+','2B3BKM1M0K/U','zh_CN','清理权限日志计划');

/*调度计划分录*/
DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '2B3BKM1M+ZE/';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('2B3BKM1M+ZE+','2B3BD572HKLT','2B3BKM1M+ZE/',1);




