/** 临时供应商失效作业定时任务 **/
DELETE FROM t_sch_taskdefine WHERE FID = '2IR1UUHTZ+SG';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('2IR1UUHTZ+SG','kd.scm.srm.common.task.SrmSupApproveTempExpiry','srm','SrmSupApproveTempExpiry'); 

DELETE FROM t_sch_taskdefine_l WHERE FID = '2IR1UUHTZ+SG' AND FLOCALEID='zh_CN';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2IR1UUHTZ+SG','2IR1UUHTZ04+','zh_CN','临时供应商失效'); 
DELETE FROM t_sch_taskdefine_l WHERE FID = '2IR1UUHTZ+SG' AND FLOCALEID='zh_TW';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2IR1UUHTZ+SG','2IR1UUHTZ04/','zh_TW','臨時供應商失效'); 

DELETE FROM T_SCH_JOB WHERE FID = '2IR2=U6GEUPQ';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('2IR2=U6GEUPQ','kd.scm.srm.common.task.SrmSupApproveTempExpiry','2IR1UUHTZ+SG','0',1,'BIZ','1','srm_supapprovetemp_expiry_SKDJ_S','0','1',0,0,'zh_CN','0','{}',0); 

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

DELETE FROM T_SCH_JOB_l WHERE FID = '2IR2=U6GEUPQ' AND FLOCALEID='zh_CN';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2IR2=U6GEUPQ','2IR2=U6GEWQH','zh_CN','临时供应商失效作业'); 
DELETE FROM T_SCH_JOB_l WHERE FID = '2IR2=U6GEUPQ' AND FLOCALEID='zh_TW';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2IR2=U6GEUPQ','2IR2=U6GEWQI','zh_TW','臨時供應商失效作業'); 


DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '2IR3=WHJ8W5J';
INSERT INTO t_sch_schedule_entry(FJOBNUMBER,FID,FENTRYID,FSEQ) VALUES ('2IR2=U6GEUPQ','2IR3=WHJ8W5I','2IR3=WHJ8W5J',1); 

DELETE FROM T_SCH_SCHEDULE WHERE FID = '2IR3=WHJ8W5I';
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 0 * * ?','0','172.19.106.183','0','0','0','0',{ts'2040-06-20  00:00:00'},'0','d','0','0','d','0','0','0','0','事件将于2022-06-20 00:00:00起，每1天0时重复。
预计最近十次执行时间：
2022-06-20 00:00:00,
2022-06-21 00:00:00,
2022-06-22 00:00:00,
2022-06-23 00:00:00,
2022-06-24 00:00:00,
2022-06-25 00:00:00,
2022-06-26 00:00:00,
2022-06-27 00:00:00,
2022-06-28 00:00:00,
2022-06-29 00:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2IR2=U6GEUPQ',{ts'2022-06-20  00:00:00'},'0','0','0','2IR3=WHJ8W5I','0','0','0','0','0',' ','1','srm_supapprovetemp_expiry_SKDP_S','0','0',1,'0','0','0','0','0'); 

DELETE FROM T_SCH_SCHEDULE_l WHERE FID = '2IR3=WHJ8W5I' AND FLOCALEID='zh_CN';
INSERT INTO T_SCH_SCHEDULE_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2IR3=WHJ8W5I','2IR3=WHJ8U4R','zh_CN','临时供应商失效计划'); 
DELETE FROM T_SCH_SCHEDULE_l WHERE FID = '2IR3=WHJ8W5I' AND FLOCALEID='zh_TW';
INSERT INTO T_SCH_SCHEDULE_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2IR3=WHJ8W5I','2IR3=WHJ8U4S','zh_TW','臨時供應商失效計劃'); 

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