DELETE FROM t_warn_schedule WHERE FID = '1494206218628218880';
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-08-24  00:00:00'},'0','1464542549678131200','kingdee',' ','1494206218628218880','1494206218628218880','每天-09:00:00','1494208640712718336','从2022-07-14开始','1','1494208640637220864','WarnScheduleModel','1494206218628218880',1661326535189,'0',{ts'2022-07-14  00:00:00'},{ts'2022-08-24  00:00:00'},{ts'2022-08-24  00:00:00'},'0',' ','HRMsgRemindThreeAdminWarningSchm',' ',1244187689457138688,'15NPDX/GJFOO',{ts'2022-07-14  00:00:00'},1244187689457138688); 

DELETE FROM T_WARN_SCHEDULE_L WHERE FPKID='2OIQ48M/9YJM';
 INSERT INTO T_WARN_SCHEDULE_L(fpkid,fid,flocaleid,fname,fdata)
 VALUES('2OIQ48M/9YJM','1494206218628218880','zh_CN','HR业务处理异常7天提醒管理员预警方案','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <WarnSchedule>
    <WarnSchedule>
      <MessageConfig>
        <WarnMessageConfig>
          <SendTypes>
            <WarnMessageSendType action="edit" oid="weixinqy">
              <Id>742567749984728064</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="yunzhijia">
              <Id>475756772099906560</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="sms">
              <Id>475773159430184960</Id>
            </WarnMessageSendType>
          </SendTypes>
        </WarnMessageConfig>
      </MessageConfig>
    </WarnSchedule>
  </WarnSchedule>
</WarnScheduleMetadata>
');
 DELETE FROM T_WARN_SCHEDULE_L WHERE FPKID='2OIQ48M/836F';
 INSERT INTO T_WARN_SCHEDULE_L(fpkid,fid,flocaleid,fname,fdata)
 VALUES('2OIQ48M/836F','1494206218628218880','en_US',' ','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <WarnSchedule>
    <WarnSchedule>
      <MessageConfig>
        <WarnMessageConfig>
          <SendTypes>
            <WarnMessageSendType action="edit" oid="weixinqy">
              <Id>742567749984728064</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="yunzhijia">
              <Id>475756772099906560</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="sms">
              <Id>475773159430184960</Id>
            </WarnMessageSendType>
          </SendTypes>
        </WarnMessageConfig>
      </MessageConfig>
    </WarnSchedule>
  </WarnSchedule>
</WarnScheduleMetadata>
');
 DELETE FROM T_SCH_TASKDEFINE WHERE fid='EW_1494206218628218880';
 INSERT INTO T_SCH_TASKDEFINE(fid,fclassname,fnumber,fappid)
 VALUES('EW_1494206218628218880','kd.bos.service.earlywarn.EarlyWarnScheduleTask','HRMsgRemindThreeAdminWarningSchm','hrcs');
 DELETE FROM T_SCH_JOB WHERE fid='1494208640637220864';
 INSERT INTO T_SCH_JOB(fid,fjobtype,ftaskclassname,frunbyuserid,fnumber,ftaskdefineid,fstatus,fparams,ftimeout,frunbyorgid,frunbylang,fconcurrent,frunmode,fstrategy,fretrytime,fcanstop)
 VALUES('1494208640637220864','BIZ','kd.bos.service.earlywarn.EarlyWarnScheduleTask',1,'HRMsgRemindThreeAdminWarningSchm','EW_1494206218628218880','1','{"warnScheduleId":"1494206218628218880"}',0,0,'zh_CN','0','0','1',0,'0');
 DELETE FROM T_SCH_JOB_L WHERE FPKID='2OIQ48I=6HGY';
 INSERT INTO T_SCH_JOB_L(fpkid,fid,flocaleid,fname)
 VALUES('2OIQ48I=6HGY','1494208640637220864','zh_CN','HR业务处理异常7天提醒管理员预警方案');
 DELETE FROM T_SCH_SCHEDULE WHERE fid='1494208640712718336';
 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('1494208640712718336','1494208640637220864',{ts'2022-07-14 09:00:00'},{ts'2122-07-14 09:00:00'},'0 0 9 ? * * *','EW_HRMsgRemindThreeAdminWarningSchm','1',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='1494208640738115584';
 INSERT INTO T_SCH_SCHEDULE_L(fpkid,fid,flocaleid,fname)
 VALUES('1494208640738115584','1494208640712718336','zh_CN','HR业务处理异常7天提醒管理员预警方案');
 
 DELETE FROM t_warn_schedule WHERE FID = '1494210021469206528';
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-08-24  00:00:00'},'0','1464542549678131200','kingdee',' ','1494210021469206528','1494210021469206528','每天-09:00:00','1494210892978700288','从2022-07-21开始','1','1494210892919980032','WarnScheduleModel','1494210021469206528',1661327246749,'0',{ts'2022-07-21  00:00:00'},{ts'2022-08-24  00:00:00'},{ts'2022-08-24  00:00:00'},'0',' ','HRMsgRemindThreeAdmiWarningSchm',' ',1244187689457138688,'15NPDX/GJFOO',{ts'2022-07-21  00:00:00'},1244187689457138688); 
 DELETE FROM T_WARN_SCHEDULE_L WHERE FPKID='2OIR8QYK/Y6K';
 INSERT INTO T_WARN_SCHEDULE_L(fpkid,fid,flocaleid,fname,fdata)
 VALUES('2OIR8QYK/Y6K','1494210021469206528','zh_CN','HR业务处理异常30天提醒管理员预警方案','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <WarnSchedule>
    <WarnSchedule>
      <MessageConfig>
        <WarnMessageConfig>
          <SendTypes>
            <WarnMessageSendType action="edit" oid="weixinqy">
              <Id>742567749984728064</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="yunzhijia">
              <Id>475756772099906560</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="sms">
              <Id>475773159430184960</Id>
            </WarnMessageSendType>
          </SendTypes>
        </WarnMessageConfig>
      </MessageConfig>
    </WarnSchedule>
  </WarnSchedule>
</WarnScheduleMetadata>
');
 DELETE FROM T_WARN_SCHEDULE_L WHERE FPKID='2OIR8QYK+2UD';
 INSERT INTO T_WARN_SCHEDULE_L(fpkid,fid,flocaleid,fname,fdata)
 VALUES('2OIR8QYK+2UD','1494210021469206528','en_US',' ','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata>
  <WarnSchedule>
    <WarnSchedule>
      <MessageConfig>
        <WarnMessageConfig>
          <SendTypes>
            <WarnMessageSendType action="edit" oid="weixinqy">
              <Id>742567749984728064</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="yunzhijia">
              <Id>475756772099906560</Id>
            </WarnMessageSendType>
            <WarnMessageSendType action="edit" oid="sms">
              <Id>475773159430184960</Id>
            </WarnMessageSendType>
          </SendTypes>
        </WarnMessageConfig>
      </MessageConfig>
    </WarnSchedule>
  </WarnSchedule>
</WarnScheduleMetadata>
');
 DELETE FROM T_SCH_TASKDEFINE WHERE fid='EW_1494210021469206528';
 INSERT INTO T_SCH_TASKDEFINE(fid,fclassname,fnumber,fappid)
 VALUES('EW_1494210021469206528','kd.bos.service.earlywarn.EarlyWarnScheduleTask','HRMsgRemindThreeAdmiWarningSchm','hrcs');
 DELETE FROM T_SCH_JOB WHERE fid='1494210892919980032';
 INSERT INTO T_SCH_JOB(fid,fjobtype,ftaskclassname,frunbyuserid,fnumber,ftaskdefineid,fstatus,fparams,ftimeout,frunbyorgid,frunbylang,fconcurrent,frunmode,fstrategy,fretrytime,fcanstop)
 VALUES('1494210892919980032','BIZ','kd.bos.service.earlywarn.EarlyWarnScheduleTask',1,'HRMsgRemindThreeAdmiWarningSchm','EW_1494210021469206528','1','{"warnScheduleId":"1494210021469206528"}',0,0,'zh_CN','0','0','1',0,'0');
 DELETE FROM T_SCH_JOB_L WHERE FPKID='2OIR8QVOK7VH';
 INSERT INTO T_SCH_JOB_L(fpkid,fid,flocaleid,fname)
 VALUES('2OIR8QVOK7VH','1494210892919980032','zh_CN','HR业务处理异常30天提醒管理员预警方案');
 DELETE FROM T_SCH_SCHEDULE WHERE fid='1494210892978700288';
 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('1494210892978700288','1494210892919980032',{ts'2022-07-21 09:00:00'},{ts'2122-07-21 09:00:00'},'0 0 9 ? * * *','EW_HRMsgRemindThreeAdmiWarningSchm','1',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='1494210893003634688';
 INSERT INTO T_SCH_SCHEDULE_L(fpkid,fid,flocaleid,fname)
 VALUES('1494210893003634688','1494210892978700288','zh_CN','HR业务处理异常30天提醒管理员预警方案');
 