-- 短链定时任务
DELETE FROM t_sch_taskdefine WHERE FID = '2A+UOS0XJX7O';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('2A+UOS0XJX7O','kd.hr.hbss.bussiness.task.HrSafeUriClearTask','hbss','hbss_clearsafeuri_task'); 
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '2A+UOS0XLP8B';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2A+UOS0XJX7O','2A+UOS0XLP8B','zh_CN','hr定时清理安全链接'); 
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '2A+UOS0XLP8C';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2A+UOS0XJX7O','2A+UOS0XLP8C','zh_TW','hr定時清理安全鏈接'); 

DELETE FROM T_SCH_JOB WHERE FID = '2A+VCOJU5MI7';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FTIMEOUT,FRUNBYLANG,FSTATUS,FPARAMS,FRUNBYORGID,FNUMBER,FCONCURRENT) VALUES ('2A+VCOJU5MI7','kd.hr.hbss.bussiness.task.HrSafeUriClearTask','2A+UOS0XJX7O',13466739,'BIZ',0,' ','1','{}',0,'hbss_clearsafeuri_work_SKDJ_S','0'); 
DELETE FROM T_SCH_JOB_L WHERE FPKID = '2A+VCOJU7EIW';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2A+VCOJU5MI7','2A+VCOJU7EIW','zh_CN','hr定时清理安全链接'); 
DELETE FROM T_SCH_JOB_L WHERE FPKID = '2A+VCOJU7EIX';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2A+VCOJU5MI7','2A+VCOJU7EIX','zh_TW','hr定時清理安全鏈接'); 

DELETE FROM T_SCH_SCHEDULE WHERE FID = '2A5V7T6269/C';
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 53 9 1 * ?','0','172.19.72.130','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','m','0','d','0','0','0','0','事件将于2022-03-16 09:53:13起，每1月的1日重复。
预计最近十次执行时间：
2022-04-01 09:53:00,
2022-05-01 09:53:00,
2022-06-01 09:53:00,
2022-07-01 09:53:00,
2022-08-01 09:53:00,
2022-09-01 09:53:00,
2022-10-01 09:53:00,
2022-11-01 09:53:00,
2022-12-01 09:53:00,
2023-01-01 09:53:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2A+VCOJU5MI7',{ts'2022-03-16  00:00:00'},'0','0','0','2A5V7T6269/C','0','1','0','0','0',' ','1','hbss_clearsafeuri_work_SKDP_S','0','0',1,'0','0','0','0','0'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2A5V7T6268B3';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2A5V7T6269/C','2A5V7T6268B3','zh_CN','hr定时清理安全链接'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2A5V7T6268B4';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2A5V7T6269/C','2A5V7T6268B4','zh_TW','hr定時清理安全鏈接'); 




-- 验证码定时任务
DELETE FROM t_sch_taskdefine WHERE FID = '2=RMLVM72NZ9';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('2=RMLVM72NZ9','kd.hr.hbss.bussiness.task.HrVerifyCodeClearTask','hbss','hbss_clearverifycode_task'); 
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '2=RMLVMD=UPO';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2=RMLVM72NZ9','2=RMLVMD=UPO','zh_CN','hr定时清理验证码日志'); 
DELETE FROM t_sch_taskdefine_l WHERE FPKID = '2=RMLVMD=UPP';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('2=RMLVM72NZ9','2=RMLVMD=UPP','zh_TW','hr定時清理驗證碼日誌'); 

DELETE FROM T_SCH_JOB WHERE FID = '2=RN05Y6YKJ6';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FTIMEOUT,FRUNBYLANG,FSTATUS,FPARAMS,FRUNBYORGID,FNUMBER,FCONCURRENT) VALUES ('2=RN05Y6YKJ6','kd.hr.hbss.bussiness.task.HrVerifyCodeClearTask','2=RMLVM72NZ9',13466739,'BIZ',0,' ','1','{}',0,'hbss_clearverifycode_work_SKDJ_S','0'); 
DELETE FROM T_SCH_JOB_L WHERE FPKID = '2=RN05Y=IB32';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2=RN05Y6YKJ6','2=RN05Y=IB32','zh_CN','hr定时清理验证码日志'); 
DELETE FROM T_SCH_JOB_L WHERE FPKID = '2=RN05Y=IB33';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2=RN05Y6YKJ6','2=RN05Y=IB33','zh_TW','hr定時清理驗證碼日誌'); 

DELETE FROM T_SCH_SCHEDULE WHERE FID = '2=RN8M+NITPP';
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 53 1,2 ? * 2','0','172.19.72.130','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','w','0','d','0','0','0','0','事件将于2022-03-11 17:53:18起，每1周的星期一1时,2时重复。
预计最近十次执行时间：
2022-03-14 01:53:00,
2022-03-14 02:53:00,
2022-03-21 01:53:00,
2022-03-21 02:53:00,
2022-03-28 01:53:00,
2022-03-28 02:53:00,
2022-04-04 01:53:00,
2022-04-04 02:53:00,
2022-04-11 01:53:00,
2022-04-11 02:53:00','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','2=RN05Y6YKJ6',{ts'2022-03-11  00:00:00'},'0','0','0','2=RN8M+NITPP','0','0','0','0','0',' ','1','hbss_clearverifycode_work_SKDP_S','0','0',1,'0','0','0','0','0'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2=RN8M+NKGBA';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2=RN8M+NITPP','2=RN8M+NKGBA','zh_CN','hr定时清理验证码日志'); 
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2=RN8M+NKGBB';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2=RN8M+NITPP','2=RN8M+NKGBB','zh_TW','hr定時清理驗證碼日誌'); 
