delete from t_cbs_archi_billset where fid = 1691440603587453952;
delete from t_cbs_archi_billset_l where fid = 1691440603587453952;
delete from t_cbs_archi_config where fid = 1691442280419862528;
delete from t_cbs_archi_config_l where fid = 1691442280419862528;
delete from t_cbs_archi_schema where fid = 1691442417959478272;
delete from t_cbs_archi_schema_L where fid = 1691442417959478272;
delete from t_cbs_archi_scheduleentry where fid = 1691442417959478272;
INSERT INTO t_cbs_archi_billset (fid, fentitynumber, fnumber, fis_store, fis_clean, fcreatetime, fpreset) VALUES (1691440603587453952, 'er_trip_log', 'er_trip_log', '0', '1', {ts'2023-05-23 17:50:13'}, '0');
INSERT INTO t_cbs_archi_billset_l (fpkid, fid, flocaleid, fname) VALUES ('3=RIDQW97XUW', 1691440603587453952, 'zh_CN', '商旅集成日志');
INSERT INTO t_cbs_archi_config (fid, fnumber, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fgroupid, fentitynumber, fcondition, fsyncbasedata, fremark, fmovingtype, fconditiontype, farchiveplugin, ffiltertype, fconditiondesc, fbillsetid, fpreset) VALUES (1691442280419862528, 'er_trip_log', 'C', 1205612035459523584, 1205612035459523584, '0', {ts'2023-05-23 17:50:13'}, {ts'2023-05-23 17:50:13'}, 1691442280419862528, 0, 'er_trip_log', '{"bill":"{\"filterRow\":[{\"id\":\"3=ULXP22DD/W\",\"leftBracket\":\"\",\"compareType\":\"501\",\"fieldName\":\"opdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"3=ULXP22DDP4\",\"value\":\"15\"}],\"baseDataIds\":[]}],\"forList\":false}"}', ' ', ' ', '1', ' ', ' ', 'bill', 'opdate < ''2023-05-14 00:00:00''', 1691440603587453952, '0');
INSERT INTO t_cbs_archi_config_l (fpkid, fid, flocaleid, fname) VALUES ('3=RIPZFY/P3K', 1691442280419862528, 'zh_CN', '商旅集成日志');
INSERT INTO t_cbs_archi_schema (fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fscheduleplanid, fendtime, fmovingtype, fexecutorid, fexecplan, fpreset) VALUES (1691442417959478272, 'ARCHIVE_CLN_20230523-175408961_SKDP_S', '商旅集成日志清除', 'A', 1205612035459523584, 1205612035459523584, '0', {ts'2023-05-23 17:50:13'}, {ts'2023-05-23 17:50:13'}, 1691442417959478272, '3=RIX59G5MEZ', {ts'2023-05-23 17:50:13'}, '1', 1205612035459523584, '事件将于2023-05-23 17:54:59起，每1天22时重复。
预计最近十次执行时间：
2023-05-23 22:54:00,
2023-05-24 22:54:00,
2023-05-25 22:54:00,
2023-05-26 22:54:00,
2023-05-27 22...', '0');
INSERT INTO t_cbs_archi_schema_l (fpkid, fid, flocaleid, fname) VALUES ('3=RIYBH8X9+=', 1691442417959478272, 'zh_CN', '商旅集成日志清除');
INSERT INTO t_cbs_archi_schema_l (fpkid, fid, flocaleid, fname) VALUES ('3=RIYBH8X9+A', 1691442417959478272, 'zh_TW', '商旅集成日誌清除');
INSERT INTO t_cbs_archi_scheduleentry (fid, fentryid, fseq, fconfigid) VALUES (1691442417959478272, 1691443431303325696, 1, 1691442280419862528);





delete from T_SCH_JOB where fid = '3=RIX53EGM8C';
delete from T_SCH_JOB_l where fid = '3=RIX53EGM8C';
delete from T_SCH_JOB_n where fid = '3=RIX53EGM8C';
delete from t_sch_schedule where fid = '3=RIX59G5MEZ';
delete from t_sch_schedule_l where fid = '3=RIX59G5MEZ';
delete from t_sch_schedule_n where fid = '3=RIX59G5MEZ';
delete from t_sch_schedule_entry where fid = '3=RIX59G5MEZ';
INSERT INTO t_sch_job (fid, fjobtype, ftaskclassname, frunbyuserid, fnumber, ftaskdefineid, fstatus, fparams, ftimeout, frunbyorgid, frunbylang, fconcurrent, frunmode, fstrategy, fretrytime, fcanstop) VALUES ('3=RIX53EGM8C', 'BIZ', 'kd.bos.cbs.plugin.archive.task.ArchiveTask', 1205612035459523584, 'ARCHIVE_CLN_20230523-175408961', '2145XJVI2N49', '0', '{"ArchiveSchemaId":1691442417959478272}', 0, 0, ' ', '0', ' ', ' ', 0, '0');
INSERT INTO t_sch_job_l (fpkid, fid, flocaleid, fname) VALUES ('3=RIX53I3134', '3=RIX53EGM8C', 'zh_CN', '商旅集成日志清除');
INSERT INTO t_sch_job_n (fid, ffailnotify, fsuccessnotify, fmsgcontent, fjobprincipal, fnotifytype, fcaption, fovertime, fjobmsgreceiver) VALUES ('3=RIX53EGM8C', '1', '0', ' ', 0, ' ', ' ', '0', 0);
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 ('3=RIX59G5MEZ', '3=RIX53EGM8C', {ts'2023-05-23 17:54:59'}, {ts'2099-12-31 17:54:59'}, '0 54 22 * * ?', 'ARCHIVE_CLN_20230523-175408961_SKDP_S', '0', 1, '172.19.109.82', '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', ' ', ' ', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'd', '事件将于2023-05-23 17:54:59起，每1天22时重复。
预计最近十次执行时间：
2023-05-23 22:54:00,
2023-05-24 22:54:00,
2023-05-25 22:54:00,
2023-05-26 22:54:00,
2023-05-27 22:54:00,
2023-05-28 22:54:00,
2023-05-29 22:54:00,
2023-05-30 22:54:00,
2023-05-31 22:54:00,
2023-06-01 22:54:00', 'd');
INSERT INTO t_sch_schedule_l (fpkid, fid, flocaleid, fname) VALUES ('3=RIX5IAIM61', '3=RIX59G5MEZ', 'zh_CN', '商旅集成日志清除');
INSERT INTO t_sch_schedule_n (fid, fschprincipal, fmsgreceiver, fsfailnotify, fssuccessnotify, fsmsgcontent, fsnotifytype, fstimeout) VALUES ('3=RIX59G5MEZ', 0, 0, '1', '0', ' ', ' ', '0');
INSERT INTO t_sch_schedule_entry (fid, fentryid, fseq, fjobnumber) VALUES ('3=RIX59G5MEZ', '3=RIX5IAIMVA', 1, '3=RIX53EGM8C');





