
/** 供应商证书预警定时任务 **/
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '0E=P21S7VVF0';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('0E=P21S7VVF0','kd.scm.srm.common.task.SrmSupplierWarningTask','srm','SRM_SUPPLIERWARINING'); 
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '0E=P21S7VZGK';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0E=P21S7VVF0','0E=P21S7VZGK','zh_CN','供应商证书预警'); 
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '0E=P21S7VZGL';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0E=P21S7VVF0','0E=P21S7VZGL','zh_TW','供應商證書預警'); 

DELETE FROM T_SCH_JOB WHERE FID = '0E=P5709LBE/';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FPARAMS,FNUMBER) VALUES ('0E=P5709LBE/','kd.scm.srm.common.task.SrmSupplierWarningTask','0E=P21S7VVF0',1,'BIZ','1',' ','srm_SUPPLIERWARINING_SKDJ_S'); 
DELETE FROM t_sch_job_l WHERE FPKID = '0E=P5709LFFJ';
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0E=P5709LBE/','0E=P5709LFFJ','zh_CN','供应商证书预警'); 
DELETE FROM t_sch_job_l WHERE FPKID = '0E=P5709LFFK';
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('0E=P5709LBE/','0E=P5709LFFK','zh_TW','供應商證書預警'); 

DELETE FROM T_SCH_SCHEDULE WHERE FID = '0EGJIIV/1YNC';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FSUN,FTWO,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,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 0 1 * * ?','0','172.19.110.160','0','0','0','0',{ts'2049-12-09  15:23:02'},'0','d','0','0','d','0','0','0','0','事件将于每1天重复','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0E=P5709LBE/',{ts'2019-12-09  01:00:00'},'0','0','0','0EGJIIV/1YNC','0','0','0','0','0',' ','1','srm_SUPWARINING_SKDP_S','0','0',1,'0','0','0','0','0'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '0EGJIIV/1ULU';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0EGJIIV/1YNC','0EGJIIV/1ULU','zh_CN','供应商证书预警'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '0EGJIIV/1ULV';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('0EGJIIV/1YNC','0EGJIIV/1ULV','zh_TW','供應商證書預警'); 
