DELETE FROM t_sch_taskdefine WHERE FID = '2ACQAAAYODVB';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('2ACQAAAYODVB','kd.scm.pbd.formplugin.task.ScDataHandleLogCleanTask','pbd','ScDataHandleLogCleanTask'); 
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '2ACQAAAYMGFM';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2ACQAAAYODVB','2ACQAAAYMGFM','zh_CN','供应商协同数据处理日志清理'); 
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '2ACQAAAYMGFN';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2ACQAAAYODVB','2ACQAAAYMGFN','zh_TW','供應商協同數據處理日誌清理'); 


DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '2ACR7SXN93BL';
INSERT INTO T_SCH_JOBPARAMS(FID,FMUST,FPARAMTYPE,FENTRYID,FSEQ,FBASEDATAINFO,FPARAMVALUE,FPARAMNAME) VALUES ('2ACQYLXLRSFW','1','1','2ACR7SXN93BL',1,' ','15','successduring'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '2ACR7SXN93BM';
INSERT INTO T_SCH_JOBPARAMS(FID,FMUST,FPARAMTYPE,FENTRYID,FSEQ,FBASEDATAINFO,FPARAMVALUE,FPARAMNAME) VALUES ('2ACQYLXLRSFW','1','1','2ACR7SXN93BM',2,' ','70','faillogduring'); 
DELETE FROM T_SCH_JOB WHERE FID = '2ACQYLXLRSFW';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('2ACQYLXLRSFW','kd.scm.pbd.formplugin.task.ScDataHandleLogCleanTask','2ACQAAAYODVB','0',74260746,'BIZ','1','pbd_ScDataHandleLogCleanTask_SKDJ_S','1','1',0,0,'zh_CN','0','{"successduring":"15","faillogduring":"70"}',0); 
DELETE FROM T_SCH_JOB_n WHERE FID = '2ACQYLXLRSFW';
INSERT INTO T_SCH_JOB_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION) VALUES ('2ACQYLXLRSFW',0,'0','0',0,' ','1',' ','调度作业通知'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '2ACQYLXLPR/M';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2ACQYLXLRSFW','2ACQYLXLPR/M','zh_CN','供应商协同数据处理日志清理'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '2ACQYLXLPR/N';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2ACQYLXLRSFW','2ACQYLXLPR/N','zh_TW','供應商協同數據處理日誌清理'); 


DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '2ACRI5EUMJM8';
INSERT INTO t_sch_schedule_entry(FJOBNUMBER,FID,FENTRYID,FSEQ) VALUES ('2ACQYLXLRSFW','2ACRI5ER/4EQ','2ACRI5EUMJM8',1); 
DELETE FROM T_SCH_SCHEDULE WHERE FID = '2ACRI5ER/4EQ';
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 31 0 * * ?','0','172.19.105.173','0','0','0','0',{ts'2055-08-18  00:00:00'},'0','d','0','0','d','0','0','0','0','事件将于2022-03-18 16:31:10起，每1天0时重复。
预计最近十次执行时间：
2022-03-19 00:31:00,
2022-03-20 00:31:00,
2022-03-21 00:31:00,
2022-03-22 00:31:00,
2022-03-23 00:31:00,
2022-03-24 00:31:00,
2022-03-25 00:31:00,
2022-03-26 00:31:00,
2022-03-27 00:31:00,
2022-03-28 00:31:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2ACQYLXLRSFW',{ts'2022-03-18  00:00:00'},'0','0','0','2ACRI5ER/4EQ','0','0','0','0','0',' ','1','pbd_ScDataHandleLogClean_SKDP_S','0','0',1,'0','0','0','0','0'); 

DELETE FROM T_SCH_SCHEDULE_l WHERE FPKID = '2ACRI5EUKI6+';
INSERT INTO T_SCH_SCHEDULE_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2ACRI5ER/4EQ','2ACRI5EUKI6+','zh_CN','供应商协同数据处理日志清理'); 
DELETE FROM T_SCH_SCHEDULE_l WHERE FPKID = '2ACRI5EUKI6/';
INSERT INTO T_SCH_SCHEDULE_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2ACRI5ER/4EQ','2ACRI5EUKI6/','zh_TW','供應商協同數據處理日誌清理'); 
DELETE FROM T_SCH_SCHEDULE_n WHERE FID = '2ACRI5ER/4EQ';
INSERT INTO T_SCH_SCHEDULE_n(FID,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('2ACRI5ER/4EQ',' ',' ',0,'0',0,'0','1'); 