/* DELETE FROM t_cbs_archi_schema WHERE FID = 1692697205330399232;
INSERT INTO t_cbs_archi_schema(FID,FSCHEDULEPLANID,FEXECUTORID,FMASTERID,FSTATUS,FNUMBER,FNAME,FCREATETIME,FMODIFIERID,FENABLE,FMODIFYTIME,FMOVINGTYPE,FCREATORID,FENDTIME,FEXECPLAN) VALUES (1692697205330399232,'2158156714158144512',1,1692697205330399232,'A','ARCHIVE_CLN_20230525-112711272_SKDP_S',' 资金反写费用日志清除',{ts'2023-05-25  00:00:00'},1,'1',{ts'2025-02-25  00:00:00'},'1',1,{ts'2099-12-31  00:00:00'},'事件将于2025-02-25 17:05:40起，每1周的星期一2时重复。
预计最近10次执行时间：
2025-03-03 02:05:00,
2025-03-10 02:05:00,
2025-03-17 02:05:00,
2025-03-24 02:05:00,
2025-03-3...'); */

-- 归档计划
UPDATE T_CBS_ARCHI_SCHEMA SET FSCHEDULEPLANID = '2158156714158144512' ,FNAME = '资金反写费用日志清除' WHERE FID = 1692697205330399232;
-- 清除规则
update t_cbs_archi_config set FCONDITION = '{"bill":"{\"filterRow\":[{\"id\":\"3=XJ23/RPIZZ\",\"leftBracket\":\"\",\"compareType\":\"501\",\"fieldName\":\"opdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"4S4VWSBKK9UO\",\"value\":\"180\"}],\"baseDataIds\":[],\"lock\":false}],\"forList\":false}"}',  FREMARK='日志保留180天'   WHERE FID = 1692696714647286784;

-- 调度计划
DELETE FROM T_SCH_SCHEDULE WHERE FID = '2158156714158144512';
INSERT INTO T_SCH_SCHEDULE(FID,FSTATUS,FDESC,FNUMBER,FPLAN,FHOST,FCREATETIME,FCYCLENUM,FMODIFIERID,FJOBID,FSTARTTIME,FMODIFYTIME,FTIMEZONEID,FENDTIME,FCREATORID,FREPEATMODE) VALUES ('2158156714158144512','1','事件自定义','ARCHIVE_CLN_20230525-112711272_SKDP_S','0 0 2 ? * 2','172.19.106.7',NULL,1,0,'4S2IA1=B59N2',{ts'2023-05-25  00:00:00'},{ts'2025-02-25  00:00:00'},0,{ts'2099-12-31  00:00:00'},1924690409268082688,'w');
DELETE FROM T_SCH_SCHEDULE_l WHERE FID = '2158156714158144512' and FLOCALEID = 'zh_CN';
INSERT INTO T_SCH_SCHEDULE_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('2158156714158144512','2158156714208352256','zh_CN',NULL,'资金反写费用日志清除');

-- 调度任务
DELETE FROM T_SCH_JOB WHERE FID = '4S2IA1=B59N2';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FTASKTRACE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FCREATETIME,FMODIFIERID,FTIMEOUT,FRETRYTIME,FMODIFYTIME,FRUNBYLANG,FCANSTOP,FCREATORID,FPARAMS,FRUNBYORGID) VALUES ('4S2IA1=B59N2','kd.bos.cbs.plugin.archive.task.ArchiveTask','2145XJVI2N49',' ',13466739,'BIZ','0','1','ARCHIVE_CLN_20230525-112711272_SKDP_S','0',' ',{ts'2025-02-25  00:00:00'},0,0,0,{ts'2025-02-25  00:00:00'},' ','0',0,'{"ArchiveSchemaId":1692697205330399232}',0);
DELETE FROM T_SCH_JOB_n WHERE FID = '4S2IA1=B59N2';
INSERT INTO T_SCH_JOB_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION,FABORTED) VALUES ('4S2IA1=B59N2',0,'0','0',0,' ','0',' ',' ','0');
DELETE FROM T_SCH_JOB_l WHERE FID = '4S2IA1=B59N2' and FLOCALEID = 'zh_CN';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES ('4S2IA1=B59N2','4S2IA1=M+ERL','zh_CN',' ','归档调度后台自动创建作业');
