DELETE FROM T_SCH_TASKDEFINE WHERE fid='EW_1464540742453199872';
 INSERT INTO T_SCH_TASKDEFINE(fid,fclassname,fnumber,fappid)
 VALUES('EW_1464540742453199872','kd.bos.service.earlywarn.EarlyWarnScheduleTask','HRMsgRemindWarningSchm','hrcs');
 DELETE FROM T_SCH_JOB WHERE fid='1464545877388592128';
 INSERT INTO T_SCH_JOB(fid,fjobtype,ftaskclassname,frunbyuserid,fnumber,ftaskdefineid,fstatus,fparams,ftimeout,frunbyorgid,frunbylang,fconcurrent,frunmode,fstrategy,fretrytime,fcanstop)
 VALUES('1464545877388592128','BIZ','kd.bos.service.earlywarn.EarlyWarnScheduleTask',1,'HRMsgRemindSevenWarningSchm','EW_1464540742453199872','1','{"warnScheduleId":"1464540742453199872"}',0,0,'zh_CN','0','0','1',0,'0');
 DELETE FROM T_SCH_JOB_L WHERE FPKID='2LGZ3/29=S94';
 INSERT INTO T_SCH_JOB_L(fpkid,fid,flocaleid,fname)
 VALUES('2LGZ3/29=S94','1464545877388592128','zh_CN','HR业务处理异常7天提醒预警方案');
 DELETE FROM T_SCH_SCHEDULE WHERE fid='1464545878042903552';
 INSERT INTO T_SCH_SCHEDULE(fid,fjobid,fstarttime,fendtime,fplan,fnumber,fstatus,fcyclenum,fhost,fsun,fsat,ffri,fthur,fwed,ftues,fmon,fone,ftwo,fthirtyone,fthirty,ftwentynine,ftwentyeight,ftwentyseven,ftwentysix,ftwentyfive,ftwentyfour,ftwentythree,ftwentytwo,ftwentyone,ftwenty,fnineteen,feighteen,fseventeen,fsixteen,ffifteen,ffourteen,fthirteen,ftwelve,feleven,ften,fnine,feight,fseven,fsix,ffive,ffour,fthree,fno,fnoweek,fjan,fdec,fnov,foct,fsep,faug,fjul,fjun,fmay,fapr,fmar,ffeb,fbyweek,fbydayorweek,fdesc,frepeatmode)
 VALUES('1464545878042903552','1464545877388592128',{ts'2022-07-21 00:00:00'},{ts'2122-07-21 00:00:00'},'0 0 0 ? * * *','EW_HRMsgRemindSevenWarningSchm','1',1,'172.19.74.73','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',null,null,'0','0','0','0','0','0','0','0','0','0','0','0','0',null,'事件将每1天重复','d');
 DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID='1464545878101624832';
 INSERT INTO T_SCH_SCHEDULE_L(fpkid,fid,flocaleid,fname)
 VALUES('1464545878101624832','1464545878042903552','zh_CN','HR业务处理异常7天提醒预警方案');
 DELETE FROM T_SCH_TASKDEFINE WHERE fid='EW_1469436832247842816';
 INSERT INTO T_SCH_TASKDEFINE(fid,fclassname,fnumber,fappid)
 VALUES('EW_1469436832247842816','kd.bos.service.earlywarn.EarlyWarnScheduleTask','HRMsgRemindThreeWarningSchm','hrcs');
 DELETE FROM T_SCH_JOB WHERE fid='1469438930825781248';
 INSERT INTO T_SCH_JOB(fid,fjobtype,ftaskclassname,frunbyuserid,fnumber,ftaskdefineid,fstatus,fparams,ftimeout,frunbyorgid,frunbylang,fconcurrent,frunmode,fstrategy,fretrytime,fcanstop)
 VALUES('1469438930825781248','BIZ','kd.bos.service.earlywarn.EarlyWarnScheduleTask',1,'HRMsgRemindThreeWarningSchm','EW_1469436832247842816','0','{"warnScheduleId":"1469436832247842816"}',0,0,'zh_CN','0','0','1',0,'0');
 DELETE FROM T_SCH_JOB_L WHERE FPKID='2LGZ2KAN=Z0/';
 INSERT INTO T_SCH_JOB_L(fpkid,fid,flocaleid,fname)
 VALUES('2LGZ2KAN=Z0/','1469438930825781248','zh_CN','HR业务处理异常30天提醒预警方案');
 DELETE FROM T_SCH_SCHEDULE WHERE fid='1469438930901278720';
 INSERT INTO T_SCH_SCHEDULE(fid,fjobid,fstarttime,fendtime,fplan,fnumber,fstatus,fcyclenum,fhost,fsun,fsat,ffri,fthur,fwed,ftues,fmon,fone,ftwo,fthirtyone,fthirty,ftwentynine,ftwentyeight,ftwentyseven,ftwentysix,ftwentyfive,ftwentyfour,ftwentythree,ftwentytwo,ftwentyone,ftwenty,fnineteen,feighteen,fseventeen,fsixteen,ffifteen,ffourteen,fthirteen,ftwelve,feleven,ften,fnine,feight,fseven,fsix,ffive,ffour,fthree,fno,fnoweek,fjan,fdec,fnov,foct,fsep,faug,fjul,fjun,fmay,fapr,fmar,ffeb,fbyweek,fbydayorweek,fdesc,frepeatmode)
 VALUES('1469438930901278720','1469438930825781248',{ts'2022-07-21 00:00:00'},{ts'2122-07-21 00:00:00'},'0 0 0 ? * * *','EW_HRMsgRemindThreeWarningSchm','0',1,'172.19.74.73','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',null,null,'0','0','0','0','0','0','0','0','0','0','0','0','0',null,'事件将每1天重复','d');
 DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID='1469438930926569472';
 INSERT INTO T_SCH_SCHEDULE_L(fpkid,fid,flocaleid,fname)
 VALUES('1469438930926569472','1469438930901278720','zh_CN','HR业务处理异常30天提醒预警方案');
 
 DELETE FROM t_warn_schedule WHERE FID = '1469436832247842816';
INSERT INTO t_warn_schedule(FMODIFYDATE,FTYPE,FEARLYWARNID,FISV,FDATA,FINHERITPATH,FMASTERID,FMONITORFREQUENCY,FPLANID,FMONITORRANGE,FENABLE,FJOBID,FMODELTYPE,FID,FVERSION,FISTEMPLATE,FSTARTDATE,FCREATEDATE,FLASTSYNCTIME,FBYENTRY,FPARENTID,FNUMBER,FPLANNUMBER,FMODIFIERID,FBIZAPPID,FENDDATE,FCREATORID) VALUES 
({ts'2022-07-21  00:00:00'},'0','1464542549678131200','kingdee','','1469436832247842816','1469436832247842816','每天-00:00:00','1469438930901278720','从2022-07-21开始','0','1469438930825781248','WarnScheduleModel','1469436832247842816',1658371249126,'0',{ts'2022-07-21  00:00:00'},{ts'2022-07-21  00:00:00'},{ts'2022-07-21  00:00:00'},'0',' ','HRMsgRemindThreeWarningSchm',' ',1244187689457138688,'15NPDX/GJFOO',{ts'2022-07-21  00:00:00'},1244187689457138688); 

DELETE FROM t_warn_schedule_l WHERE FPKID = '2LGZ2KDQ/RI7';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1469436832247842816','2LGZ2KDQ/RI7','zh_CN','','HR业务处理异常30天提醒预警方案'); 


DELETE FROM t_warn_schedule WHERE FID = '1464540742453199872';
INSERT INTO t_warn_schedule(FMODIFYDATE,FTYPE,FEARLYWARNID,FISV,FDATA,FINHERITPATH,FMASTERID,FMONITORFREQUENCY,FPLANID,FMONITORRANGE,FENABLE,FJOBID,FMODELTYPE,FID,FVERSION,FISTEMPLATE,FSTARTDATE,FCREATEDATE,FLASTSYNCTIME,FBYENTRY,FPARENTID,FNUMBER,FPLANNUMBER,FMODIFIERID,FBIZAPPID,FENDDATE,FCREATORID) VALUES 
({ts'2022-07-21  00:00:00'},'0','1464542549678131200','kingdee','','1464540742453199872','1464540742453199872','每天-00:00:00','1464545878042903552','从2022-07-21开始','1','1464545877388592128','WarnScheduleModel','1464540742453199872',1658371256153,'0',{ts'2022-07-21  00:00:00'},{ts'2022-07-14  00:00:00'},{ts'2022-07-21  00:00:00'},'0',' ','HRMsgRemindSevenWarningSchm',' ',1244187689457138688,'15NPDX/GJFOO',{ts'2022-07-21  00:00:00'},1244187689457138688); 
DELETE FROM t_warn_schedule_l WHERE FPKID = '2LGZ3/4VWHSS';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1464540742453199872','2LGZ3/4VWHSS','zh_CN','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <WarnSchedule>
    <WarnSchedule>
      <MessageConfig>
        <WarnMessageConfig>
          <SendTypes>
            <WarnMessageSendType action="edit" oid="yunzhijia">
              <Id>475756772099906560</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="weixinqy">
              <Id>742567749984728064</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="sms">
              <Id>475773159430184960</Id>
            </WarnMessageSendType>
          </SendTypes>
        </WarnMessageConfig>
      </MessageConfig>
    </WarnSchedule>
  </WarnSchedule>
</WarnScheduleMetadata>
','HR业务处理异常7天提醒预警方案'); 
DELETE FROM t_warn_schedule_l WHERE FPKID = '2LGZ3/4VUDNH';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1464540742453199872','2LGZ3/4VUDNH','en_US','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <WarnSchedule>
    <WarnSchedule>
      <MessageConfig>
        <WarnMessageConfig>
          <SendTypes>
            <WarnMessageSendType action="edit" oid="yunzhijia">
              <Id>475756772099906560</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="weixinqy">
              <Id>742567749984728064</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="sms">
              <Id>475773159430184960</Id>
            </WarnMessageSendType>
          </SendTypes>
        </WarnMessageConfig>
      </MessageConfig>
    </WarnSchedule>
  </WarnSchedule>
</WarnScheduleMetadata>
',' '); 






 