DELETE FROM t_sch_taskdefine WHERE FID = '2DAFGO=PDQ8H';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('2DAFGO=PDQ8H','kd.mmc.mrp.task.MRPClearDataTask','mrp','MRPClearDataTask'); 
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '2DAFGO=PDQXR';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2DAFGO=PDQ8H','2DAFGO=PDQXR','zh_CN','MRP运算日志清理调度任务'); 
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '2DAFGO=PDQXS';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2DAFGO=PDQ8H','2DAFGO=PDQXS','zh_TW','MRP運算日誌清理調度任務'); 

DELETE FROM T_SCH_JOB WHERE FID = '2DAGG1KDBCK9';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('2DAGG1KDBCK9','kd.mmc.mrp.task.MRPClearDataTask','2DAFGO=PDQ8H','0',13466739,'BIZ','1','mrp_MRPClearDataTask_SKDJ_S','1','1',0,0,'0','{"reservedays":"180"}',100000); 
DELETE FROM T_SCH_JOB_L WHERE FPKID = '2DAGG1KDBBX/';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2DAGG1KDBCK9','2DAGG1KDBBX/','zh_CN','MRP运算日志清理调度作业'); 
DELETE FROM T_SCH_JOB_L WHERE FPKID = '2DAGG1KDBBX0';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2DAGG1KDBCK9','2DAGG1KDBBX0','zh_TW','MRP運算日誌清理調度作業'); 

DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '2DAH2/H0BO3N';
INSERT INTO T_SCH_JOBPARAMS(FID,FMUST,FPARAMTYPE,FENTRYID,FBASEDATAINFO,FPARAMVALUE,FPARAMNAME) VALUES ('2DAGG1KDBCK9','1','1','2DAH2/H0BO3N',' ','180','reservedays'); 

DELETE FROM T_SCH_SCHEDULE WHERE FID = '2DAHRTNMZ=Z2';
INSERT INTO T_SCH_SCHEDULE(FID,FHOST,FJOBID,FSTARTTIME,FENDTIME,FDESC,FNUMBER,FREPEATMODE) VALUES ('2DAHRTNMZ=Z2','172.19.114.79','2DAGG1KDBCK9',{ts'2022-04-20  00:00:00'},{ts'2099-12-31  00:00:00'},'事件不重复','mrp_MRPClearDataTask_SKDP_S','n'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2DAHRTNMZAMB';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2DAHRTNMZ=Z2','2DAHRTNMZAMB','zh_CN','MRP运算日志清理调度计划'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2DAHRTNMZAMC';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2DAHRTNMZ=Z2','2DAHRTNMZAMC','zh_TW','MRP運算日誌清理調度計劃'); 

DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '2DAHRTNMZ=Z3';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID) VALUES ('2DAHRTNMZ=Z2','2DAGG1KDBCK9','2DAHRTNMZ=Z3'); 


