DELETE FROM T_SCH_TASKDEFINE WHERE FID = 'EW_1230281669915757568';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('EW_1230281669915757568','kd.bos.service.earlywarn.EarlyWarnScheduleTask','srm','srm_qualification_warn'); 

DELETE FROM T_SCH_TASKDEFINE WHERE FID = 'EW_1208520049963368448';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('EW_1208520049963368448','kd.bos.service.earlywarn.EarlyWarnScheduleTask','srm','adm_qualification_warn'); 



DELETE FROM T_SCH_JOB WHERE FID = '1230283226313032704';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FTIMEOUT,FRUNBYLANG,FPARAMS,FRUNBYORGID) VALUES ('1230283226313032704','kd.bos.service.earlywarn.EarlyWarnScheduleTask','EW_1230281669915757568',1,'BIZ','1','srm_qualification_warn000','0',0,'zh-CN','{"warnScheduleId":"1230281669915757568"}',0); 

DELETE FROM T_SCH_JOB_L WHERE FPKID = '1VY5ACWT+C01';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1230283226313032704','1VY5ACWT+C01','zh_CN','采购方_供应商资质证书到期预警方案');



DELETE FROM T_SCH_JOB WHERE FID = '1208528720881583104';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FTIMEOUT,FRUNBYLANG,FPARAMS,FRUNBYORGID) VALUES ('1208528720881583104','kd.bos.service.earlywarn.EarlyWarnScheduleTask','EW_1208520049963368448',1,'BIZ','1','adm_qualification_warn','0',0,'zh-CN','{"warnScheduleId":"1208520049963368448"}',0); 

DELETE FROM T_SCH_JOB_l WHERE FPKID = '1VY5AWS/U8JP';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('1208528720881583104','1VY5AWS/U8JP','zh_CN','供应商方_供应商资质证书到期预警方案'); 


DELETE FROM T_SCH_SCHEDULE WHERE FID = '1VY63TBY0F8B';
INSERT INTO T_SCH_SCHEDULE(FID,FPLAN,FHOST,FCYCLENUM,FJOBID,FSTARTTIME,FSTATUS,FDESC,FENDTIME,FREPEATMODE,FNUMBER) VALUES ('1VY63TBY0F8B','0 0 0 * * ?','10.10.33.113',1,'1208528720881583104',{ts'2021-09-03  00:00:00'},'1','事件将于2021-09-03 00:00:00起，
每1天重复。
预计最近十次执行时间：
2021-09-03 00:00:00,
2021-09-04 00:00:00,
2021-09-05 00:00:00,
2021-09-06 00:00:00,
2021-09-07 00:00:00,
2021-09-08 00:00:00,
2021-09-09 00:00:00,
2021-09-10 00:00:00,
2021-09-11 00:00:00,
2021-09-12 00:00:00',{ts'2121-09-03  00:00:00'},'d','adm_qualification_sdkp_s'); 


DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '1VY63TBY0EK2';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1VY63TBY0F8B','1VY63TBY0EK2','zh_CN','资质证书过期调度计划_供应商'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '1VY63TBY0EK3';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1VY63TBY0F8B','1VY63TBY0EK3','zh_TW','資質證書過期調度計劃_供應商'); 


DELETE FROM T_SCH_SCHEDULE WHERE FID = '1VY5O0=G=1L8';
INSERT INTO T_SCH_SCHEDULE(FID,FPLAN,FHOST,FCYCLENUM,FJOBID,FSTARTTIME,FSTATUS,FDESC,FENDTIME,FREPEATMODE,FNUMBER) VALUES ('1VY5O0=G=1L8','0 0 0 * * ?','10.10.33.207',1,'1230283226313032704',{ts'2021-09-03  00:00:00'},'1','事件将于2021-09-03 00:00:00起，
每1天0时重复。
预计最近十次执行时间：
2021-09-03 00:00:00,
2021-09-04 00:00:00,
2021-09-05 00:00:00,
2021-09-06 00:00:00,
2021-09-07 00:00:00,
2021-09-08 00:00:00,
2021-09-09 00:00:00,
2021-09-10 00:00:00,
2021-09-11 00:00:00,
2021-09-12 00:00:00',{ts'2121-08-03  00:00:00'},'d','srm_qualification_sdkp_s'); 

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '1VY5O0=G9=ZZ';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1VY5O0=G=1L8','1VY5O0=G9=ZZ','zh_CN','资质预警调度计划_采购方'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '1VY5O0=G9A++';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1VY5O0=G=1L8','1VY5O0=G9A++','zh_TW','資質預警調度計劃_采購方'); 