/*调度任务类名*/
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '3MDB=IZ5DUWZ';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3MDB=IZ5DUWZ','kd.fi.bcm.task.CleanDimCacheScheduleTask','cm','bcm_CleanDimCacheScheduleTask');

DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '3MDB=IZF=1T8';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3MDB=IZ5DUWZ','3MDB=IZF=1T8','zh_CN','定时清理维度本地缓存');


/*调度作业*/
DELETE FROM T_SCH_JOB WHERE FID = '3M7XQP6D8S6I';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FRUNMODE,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FPARAMS,FRUNBYORGID) VALUES ('3M7XQP6D8S6I','kd.fi.bcm.task.CleanDimCacheScheduleTask','0','3MDB=IZ5DUWZ',1,'BIZ','1','cm_bcm_cleandimcache_task_SKDJ_S','0','1',0,0,' ','{}',0);
DELETE FROM T_SCH_JOB_L WHERE FPKID = '3M7XQP6D8SVS';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3M7XQP6D8S6I','3M7XQP6D8SVS','zh_CN','定时清理维度本地缓存');

/*调度计划*/
DELETE FROM T_SCH_SCHEDULE WHERE FID = '3M7XX2XIZJIQ';
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,FTWENTYSIX,FTHIRTEEN,FTWENTYSEVEN,FDESC,FAUG,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 41 6 * * ?','0','172.19.105.100','0','0','0','0',{ts'2030-12-31  00:00:00'},'0','0','d','0','d','0','0','0','事件将于2023-10-10 19:41:23起，每1天6时重复。
预计最近十次执行时间：
2023-10-11 06:41:00,
2023-10-12 06:41:00,
2023-10-13 06:41:00,
2023-10-14 06:41:00,
2023-10-15 06:41:00,
2023-10-16 06:41:00,
2023-10-17 06:41:00,
2023-10-18 06:41:00,
2023-10-19 06:41:00,
2023-10-20 06:41:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3M7XQP6D8S6I',{ts'2023-10-10  00:00:00'},'0','0','0','3M7XX2XIZJIQ','0','0','0','0','0',' ','0','cm_cleandimcache_task_SKDP_S','0','0',1,'0','0','0','0','0');

DELETE FROM t_sch_schedule_l WHERE FPKID = '3M7XX2XIZIVG';
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3M7XX2XIZJIQ','3M7XX2XIZIVG','zh_CN','定时清理维度本地缓存');
/*调度计划分录*/

DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '3M7XX2XIZJIR';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3M7XX2XIZJIQ','3M7XQP6D8S6I','3M7XX2XIZJIR',1);