DELETE FROM t_sch_taskdefine WHERE FID = '2MN0PSZ5A40T';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('2MN0PSZ5A40T','kd.mmc.mrp.task.ClearSimulationTask','mrp','autoclearsimulation'); 

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '2MN0PSZ5A4Q1';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2MN0PSZ5A40T','2MN0PSZ5A4Q1','zh_CN','自动清理模拟过期数据'); 
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '2MN0PSZ5A4Q2';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2MN0PSZ5A40T','2MN0PSZ5A4Q2','zh_TW','自動清理模擬過期數據'); 

DELETE FROM T_SCH_JOB WHERE FID = '2MN1EG/DTF5R';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('2MN1EG/DTF5R','kd.mmc.mrp.task.ClearSimulationTask','2MN0PSZ5A40T','0',13466739,'BIZ','1','mrp_CLEARSIMULATION_SKDJ_S','0','1',0,0,' ','0','{}',0); 

DELETE FROM T_SCH_JOB_n WHERE FID = '2MN1EG/DTF5R';
INSERT INTO T_SCH_JOB_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION) VALUES ('2MN1EG/DTF5R',0,'0','0',0,' ','1',' ','调度作业通知'); 

DELETE FROM T_SCH_JOB_l WHERE FPKID = '2MN1EG/DTEHH';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2MN1EG/DTF5R','2MN1EG/DTEHH','zh_CN','处理超期模拟计划'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '2MN1EG/DTEHI';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2MN1EG/DTF5R','2MN1EG/DTEHI','zh_TW','處理超期模擬計劃'); 

DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '2MN5RY6=/J1E';
INSERT INTO t_sch_schedule_entry(FJOBNUMBER,FID,FENTRYID,FSEQ) VALUES ('2MN1EG/DTF5R','2MN5RY66D3VX','2MN5RY6=/J1E',1); 

DELETE FROM T_SCH_SCHEDULE WHERE FID = '2MN5RY66D3VX';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FTWO,FSUN,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,FTEN,FTHUR,FFRI,FJOBID,FSTARTTIME,FOCT,FAPR,FSIXTEEN,FID,FONE,FSAT,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 3 * * ?','0','172.19.110.241','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','d','0','0','d','0','0','0','0','事件将于2022-08-03 00:00:00起，每1天3时重复。
预计最近十次执行时间：
2022-08-03 03:00:00,
2022-08-04 03:00:00,
2022-08-05 03:00:00,
2022-08-06 03:00:00,
2022-08-07 03:00:00,
2022-08-08 03:00:00,
2022-08-09 03:00:00,
2022-08-10 03:00:00,
2022-08-11 03:00:00,
2022-08-12 03:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2MN1EG/DTF5R',{ts'2022-08-03  00:00:00'},'0','0','0','2MN5RY66D3VX','0','0','0','0','0',' ','1','CLEARSIMULATION','0','0',1,'0','0','0','0','0'); 

DELETE FROM T_SCH_SCHEDULE_l WHERE FPKID = '2MN5RY6=/ID5';
INSERT INTO T_SCH_SCHEDULE_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2MN5RY66D3VX','2MN5RY6=/ID5','zh_CN','清理过期模拟计划'); 
DELETE FROM T_SCH_SCHEDULE_l WHERE FPKID = '2MN5RY6=/ID6';
INSERT INTO T_SCH_SCHEDULE_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2MN5RY66D3VX','2MN5RY6=/ID6','zh_TW','清理過期模擬計劃'); 

DELETE FROM T_SCH_SCHEDULE_n WHERE FID = '2MN5RY66D3VX';
INSERT INTO T_SCH_SCHEDULE_n(FID,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('2MN5RY66D3VX',' ',' ',0,'0',0,'0','1'); 