DELETE FROM t_sch_taskdefine WHERE FID = '3GHEZ/EPY5H7';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3GHEZ/EPY5H7','kd.scm.pur.business.task.PurScheduleNotTimelyDeliverTask','pur','schedulenottimelydeliver'); 

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '3GHEZ/EQ+8Z8';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3GHEZ/EPY5H7','3GHEZ/EQ+8Z8','zh_CN','交货计划交期风险预警调度类'); 
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '3GHEZ/EQ+8Z9';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3GHEZ/EPY5H7','3GHEZ/EQ+8Z9','zh_TW','交貨計劃交期風險預警調度類'); 

DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '3GHGH8GOKCB1';
INSERT INTO T_SCH_JOBPARAMS(FID,FMUST,FPARAMTYPE,FENTRYID,FSEQ,FBASEDATAINFO,FPARAMVALUE,FPARAMNAME) VALUES ('3GHFEQ39GGTF','1','0','3GHGH8GOKCB1',1,' ','sumoutstockqty','filterfield'); 
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '3GHI/R94SR57';
INSERT INTO T_SCH_JOBPARAMS(FID,FMUST,FPARAMTYPE,FENTRYID,FSEQ,FBASEDATAINFO,FPARAMVALUE,FPARAMNAME) VALUES ('3GHFEQ39GGTF','1','0','3GHI/R94SR57',2,' ','nottimelydeliverwarning','operateKey'); 

DELETE FROM T_SCH_JOB WHERE FID = '3GHFEQ39GGTF';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('3GHFEQ39GGTF','kd.scm.pur.business.task.PurScheduleNotTimelyDeliverTask','3GHEZ/EPY5H7','0',1,'BIZ','1','pur_schedulenottimelydelivertask_SKDJ_S','0','1',0,0,' ','0','{"filterfield":"sumoutstockqty","operateKey":"nottimelydeliverwarning"}',0); 

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

DELETE FROM T_SCH_JOB_l WHERE FPKID = '3GHFEQ39KNQH';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3GHFEQ39GGTF','3GHFEQ39KNQH','zh_CN','交货计划未及时交货调度作业'); 
DELETE FROM T_SCH_JOB_l WHERE FPKID = '3GHFEQ39KNQI';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3GHFEQ39GGTF','3GHFEQ39KNQI','zh_TW','交貨計劃未及時交貨調度作業'); 

DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '3GHRE9+HK0OO';
INSERT INTO t_sch_schedule_entry(FJOBNUMBER,FID,FENTRYID,FSEQ) VALUES ('3GHFEQ39GGTF','3GHRE9+HK0ON','3GHRE9+HK0OO',1); 

DELETE FROM T_SCH_SCHEDULE WHERE FID = '3GHRE9+HK0ON';
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 12 16 * * ?','0','172.19.105.173','0','0','0','0',{ts'2049-08-04  00:00:00'},'0','d','0','0','d','0','0','0','0','事件将于2023-08-07 13:12:27起，每1天16时重复。
预计最近十次执行时间：
2023-08-07 16:12:00,
2023-08-08 16:12:00,
2023-08-09 16:12:00,
2023-08-10 16:12:00,
2023-08-11 16:12:00,
2023-08-12 16:12:00,
2023-08-13 16:12:00,
2023-08-14 16:12:00,
2023-08-15 16:12:00,
2023-08-16 16:12:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3GHFEQ39GGTF',{ts'2023-08-07  00:00:00'},'0','0','0','3GHRE9+HK0ON','0','0','0','0','0',' ','0','pur_schedulenottimelydelivertask_SKDP_S','0','0',1,'0','0','0','0','0'); 

DELETE FROM T_SCH_SCHEDULE_l WHERE FPKID = '3GHRE9+HQSXX';
INSERT INTO T_SCH_SCHEDULE_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3GHRE9+HK0ON','3GHRE9+HQSXX','zh_CN','交货计划未及时交货调度计划'); 
DELETE FROM T_SCH_SCHEDULE_l WHERE FPKID = '3GHRE9+HQSXY';
INSERT INTO T_SCH_SCHEDULE_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3GHRE9+HK0ON','3GHRE9+HQSXY','zh_TW','交貨計劃未及時交貨調度計劃'); 

DELETE FROM T_SCH_SCHEDULE_n WHERE FID = '3GHRE9+HK0ON';
INSERT INTO T_SCH_SCHEDULE_n(FID,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('3GHRE9+HK0ON',' ',' ',0,'0',0,'0','1'); 
