DELETE FROM T_Warn_Schedule WHERE FID = '1462267747965768704';
INSERT INTO T_Warn_Schedule(FMODIFYDATE,FTYPE,FEARLYWARNID,FISV,FDATA,FINHERITPATH,FMASTERID,FPLANID,FMONITORFREQUENCY,FMONITORRANGE,FENABLE,FJOBID,FMODELTYPE,FID,FVERSION,FISTEMPLATE,FSTARTDATE,FCREATEDATE,FLASTSYNCTIME,FPARENTID,FNUMBER,FMODIFIERID,FBIZAPPID,FENDDATE,FCREATORID) VALUES ({ts'2022-07-15  00:00:00'},'0','1462267301070965760','kingdee',' ','1462267747965768704','1462267747965768704','1462268806951930880','每天-08:00:00','从2022-07-11开始','0','1462268806599609344','WarnScheduleModel','1462267747965768704',1657872590974,'0',{ts'2022-07-11  00:00:00'},{ts'2022-07-11  00:00:00'},{ts'2022-07-15  00:00:00'},' ','VMIMaterialWareMsg',1,'eae607fb000152ac',{ts'2022-07-11  00:00:00'},1); 


 
 DELETE FROM T_Warn_Schedule_L WHERE FID='1462267747965768704' and FLOCALEID='zh_CN';
INSERT INTO T_Warn_Schedule_L(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1462267747965768704','2KZXHSA/PB4P','zh_CN','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata/>
','VMI物料缺货预警'); 
DELETE FROM T_Warn_Schedule_L WHERE FID='1462267747965768704' and FLOCALEID='en_US';
INSERT INTO T_Warn_Schedule_L(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1462267747965768704','2KZXHSA3AS/G','en_US','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata/>
',' '); 
DELETE FROM T_Warn_Schedule_L WHERE FID='1462267747965768704' and FLOCALEID='zh_TW';
INSERT INTO T_Warn_Schedule_L(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1462267747965768704','2KZXHSA6Z5IQ','zh_TW','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <WarnSchedule>
    <WarnSchedule>
      <Name>VMI物料缺貨預警</Name>
    </WarnSchedule>
  </WarnSchedule>
</WarnScheduleMetadata>
','VMI物料缺貨預警'); 


DELETE FROM T_SCH_JOB WHERE FID = '1462268806599609344';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FTIMEOUT,FRUNBYLANG,FSTATUS,FPARAMS,FRUNBYORGID,FNUMBER,FCONCURRENT) VALUES ('1462268806599609344','kd.bos.service.earlywarn.EarlyWarnScheduleTask','EW_1462267747965768704',1,'BIZ',0,'zh_CN','0','{"warnScheduleId":"1462267747965768704"}',0,'VMIMaterialWareMsg','0'); 


DELETE FROM T_SCH_JOB_L WHERE FID='1462268806599609344' and FLOCALEID='zh_CN';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1462268806599609344','2KZXHS7Z0NG0','zh_CN','VMI物料缺货预警'); 

DELETE FROM T_SCH_SCHEDULE WHERE FID = '1462268806951930880';
INSERT INTO T_SCH_SCHEDULE(FID,FPLAN,FHOST,FCYCLENUM,FJOBID,FSTARTTIME,FSTATUS,FDESC,FENDTIME,FREPEATMODE,FNUMBER) VALUES ('1462268806951930880','0 0 8 ? * * *','172.19.106.45',1,'1462268806599609344',{ts'2022-07-11  00:00:00'},'0','事件将每1天重复',{ts'2122-07-11  00:00:00'},'d','EW_VMIMaterialWareMsg'); 

DELETE FROM T_SCH_SCHEDULE_L WHERE FID='1462268806951930880' and FLOCALEID='zh_CN';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1462268806951930880','1462268807035917312','zh_CN','VMI物料缺货预警'); 


DELETE FROM T_SCH_TASKDEFINE WHERE FID = 'EW_1462267747965768704';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('EW_1462267747965768704','kd.bos.service.earlywarn.EarlyWarnScheduleTask','scp','VMI物料缺货预警'); 


