DELETE FROM t_warn_schedule WHERE FID = '1426693201913220096';
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-05-24  00:00:00'},'0','1426692969397783552','kingdee',' ','1426693201913220096','1426693201913220096','每天-07:00:00','1426696525639092224','从2022-05-22开始','1','1426696524129142784','WarnScheduleModel','1426693201913220096',1653357157304,'0',{ts'2022-05-22  00:00:00'},{ts'2022-05-23  00:00:00'},{ts'2022-05-24  00:00:00'},'0',' ','arap_datacheck_warn_s',' ',13466739,'+HKZHSKFXOX',{ts'2022-05-22  00:00:00'},13466739);
DELETE FROM t_warn_schedule_l WHERE FPKID = '2GAF3ZDK9NGL';
INSERT INTO t_warn_schedule_l(FID,FPKID,FLOCALEID,FDATA,FNAME) VALUES ('1426693201913220096','2GAF3ZDK9NGL','zh_CN','<?xml version="1.0" encoding="UTF-8"?>

<WarnScheduleMetadata/>
','应收应付数据巡查预警');

DELETE FROM t_sch_taskdefine WHERE FID = 'EW_1426693201913220096';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('EW_1426693201913220096','kd.bos.service.earlywarn.EarlyWarnScheduleTask','ap','arap_datacheck_warn');
DELETE FROM T_SCH_JOB WHERE FID = '1426696524129142784';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('1426696524129142784','kd.bos.service.earlywarn.EarlyWarnScheduleTask','EW_1426693201913220096','0',1,'BIZ','1','ap_datacheck_warn_SKDJ_S','0','1',0,0,'zh_CN','0','{"warnScheduleId":"1426693201913220096"}',0);
DELETE FROM t_sch_job_l WHERE FPKID = '2GAF3Z23D0B4';
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1426696524129142784','2GAF3Z23D0B4','zh_CN','应收应付数据巡查预警调度作业');
DELETE FROM t_sch_job_l WHERE FPKID = '2GEISINQA4X5';
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1426696524129142784','2GEISINQA4X5','zh_TW','應收應付數據巡查預警調度作業');
DELETE FROM T_SCH_SCHEDULE WHERE FID = '1426696525639092224';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FSUN,FTWO,FEIGHT,FNOV,FPLAN,FWED,FHOST,FTWENTYTWO,FFOUR,FMAR,FSEP,FENDTIME,FSIX,FMAY,FREPEATMODE,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSEVEN,FTWENTYSIX,FTHIRTEEN,FAUG,FDESC,FFIFTEEN,FTWENTYONE,FBYWEEK,FTUES,FSEVENTEEN,FSEVEN,FTWENTYFOUR,FMON,FTHIRTY,FTHREE,FFOURTEEN,FJAN,FNINETEEN,FTHUR,FTEN,FFRI,FJOBID,FSTARTTIME,FOCT,FAPR,FSIXTEEN,FID,FSAT,FONE,FTWENTYEIGHT,FTWENTYTHREE,FTWELVE,FNOWEEK,FSTATUS,FNUMBER,FTWENTYFIVE,FEIGHTEEN,FCYCLENUM,FTWENTYNINE,FJUL,FDEC,FJUN,FFEB) VALUES ('0','0','0','0',NULL,'0','0','0','0','0 0 7 * * ?','0','172.19.148.4','0','0','0','0',{ts'2122-05-22  00:00:00'},'0','0','d','0',NULL,'0','0','0','0','事件将于2022-05-22 07:00:00起，每1天7时重复。
预计最近十次执行时间：
2022-05-22 07:00:00,
2022-05-23 07:00:00,
2022-05-24 07:00:00,
2022-05-25 07:00:00,
2022-05-26 07:00:00,
2022-05-27 07:00:00,
2022-05-28 07:00:00,
2022-05-29 07:00:00,
2022-05-30 07:00:00,
2022-05-31 07:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1426696524129142784',{ts'2022-05-22  00:00:00'},'0','0','0','1426696525639092224','0','0','0','0','0',NULL,'1','ap_datacheck_warn_SKDP_S','0','0',1,'0','0','0','0','0');
DELETE FROM t_sch_schedule_l WHERE FPKID = '1426696526041746432';
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1426696525639092224','1426696526041746432','zh_CN','应收应付数据巡查预警计划');
DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '2GEIC5A4KTR/';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('1426696525639092224','1426696524129142784','2GEIC5A4KTR/',1);

-- 调度计划预置
DELETE FROM t_sch_taskdefine WHERE FID = '2GEHXL2=L2Y9';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('2GEHXL2=L2Y9','kd.fi.arapcommon.check.impl.DataCheckScheduleTask','ap','arap_datacheck_task');
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '2GEHXL2=L29/';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2GEHXL2=L2Y9','2GEHXL2=L29/','zh_CN','数据巡查调度任务执行类');
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '2GEHXL2=L290';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2GEHXL2=L2Y9','2GEHXL2=L290','zh_TW','數據巡查調度任務執行類');

DELETE FROM T_SCH_JOB WHERE FID = '2GEI2=YDXZIY';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FTIMEOUT,FRUNBYLANG,FSTATUS,FPARAMS,FRUNBYORGID,FNUMBER,FCONCURRENT) VALUES ('2GEI2=YDXZIY','kd.fi.arapcommon.check.impl.DataCheckScheduleTask','2GEHXL2=L2Y9',13466739,'BIZ',0,' ','1','{}',0,'ap_datacheck_SKDJ_S','0');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '2GEI2=YDXYVO';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2GEI2=YDXZIY','2GEI2=YDXYVO','zh_CN','应收应付数据巡查调度作业');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '2GEI2=YDXYVP';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2GEI2=YDXZIY','2GEI2=YDXYVP','zh_TW','應收應付數據巡查調度作業');

DELETE FROM T_SCH_SCHEDULE WHERE FID = '2GEIWBTBE7EQ';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FSUN,FTWO,FEIGHT,FNOV,FPLAN,FWED,FHOST,FTWENTYTWO,FFOUR,FMAR,FSEP,FENDTIME,FSIX,FMAY,FREPEATMODE,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSEVEN,FTWENTYSIX,FTHIRTEEN,FAUG,FDESC,FFIFTEEN,FTWENTYONE,FBYWEEK,FTUES,FSEVENTEEN,FSEVEN,FTWENTYFOUR,FMON,FTHIRTY,FTHREE,FFOURTEEN,FJAN,FNINETEEN,FTHUR,FTEN,FFRI,FJOBID,FSTARTTIME,FOCT,FAPR,FSIXTEEN,FID,FSAT,FONE,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 1 * * ?','0','172.19.148.4','0','0','0','0',{ts'2099-12-25  00:00:00'},'0','0','d','0','d','0','0','0','0','事件将于2022-05-01 00:00:00起，每1天1时重复。
预计最近十次执行时间：
2022-05-01 01:00:00,
2022-05-02 01:00:00,
2022-05-03 01:00:00,
2022-05-04 01:00:00,
2022-05-05 01:00:00,
2022-05-06 01:00:00,
2022-05-07 01:00:00,
2022-05-08 01:00:00,
2022-05-09 01:00:00,
2022-05-10 01:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2GEI2=YDXZIY',{ts'2022-05-01  00:00:00'},'0','0','0','2GEIWBTBE7EQ','0','0','0','0','0',' ','1','ap_datacheck_SKDP_S','0','0',1,'0','0','0','0','0');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2GEIWBTBE6RG';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2GEIWBTBE7EQ','2GEIWBTBE6RG','zh_CN','应收应付数据巡查执行计划');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2GEIWBTBE6RH';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2GEIWBTBE7EQ','2GEIWBTBE6RH','zh_TW','應收應付數據巡查執行計劃');
DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '2GEIWBTBE7ER';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('2GEIWBTBE7EQ','2GEI2=YDXZIY','2GEIWBTBE7ER',1);
