
delete  from t_cbs_archi_billset where fid = 2153049284935812096;
delete  from t_cbs_archi_billset_l where fid = 2153049284935812096;

INSERT INTO t_cbs_archi_billset (fid, fentitynumber, fnumber, fis_store, fis_clean, fcreatetime, fpreset, fis_sync) VALUES (2153049284935812096, 'er_invoicelog', 'er_invoicelog', '0', '1', {ts'2025-02-18 15:23:59'}, '0', '0');
INSERT INTO t_cbs_archi_billset_l (fpkid, fid, flocaleid, fname) VALUES ('4RG1/A4DZI0Y', 2153049284935812096, 'zh_CN', '发票云交互日志');


delete  from t_cbs_archi_config where fid = 2153050561228855296;
delete  from t_cbs_archi_config_l where fid = 2153050561228855296;
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, fregion, ftarget_type) VALUES (2153050561228855296, 'er_invoicelog', 'C', 1924580445052322816, 1924580445052322816, '1', {ts'2025-02-18 15:19:48'}, {ts'2025-02-18 15:19:48'}, 2153050561228855296, 0, 'er_invoicelog', '{"bill":"{\"filterRow\":[{\"id\":\"4RG1641LGM=G\",\"leftBracket\":\"\",\"compareType\":\"24\",\"fieldName\":\"opdate\",\"rightBracket\":\"\",\"logic\":\"0\",\"value\":[{\"id\":\"4RG1641LES90\",\"value\":\"\"}],\"baseDataIds\":[],\"lock\":false}],\"forList\":false}"}', ' ', ' ', '1', ' ', ' ', 'bill', 'opdate >= ''2024-11-18 00:00:00'' AND opdate < ''2025-02-19 00:00:00''', 2153049284935812096, '0', ' ', ' ');
INSERT INTO t_cbs_archi_config_l (fpkid, fid, flocaleid, fname) VALUES ('4RG18LVVFN=J', 2153050561228855296, 'zh_CN', '发票云交互日志');



delete  from T_SCH_JOB where fid = '4RG1HC/O8Y1G';
delete  from T_SCH_JOB_n where fid = '4RG1HC/O8Y1G';
delete  from T_SCH_JOB_l where fid = '4RG1HC/O8Y1G';
INSERT INTO t_sch_job (fid, fjobtype, ftaskclassname, frunbyuserid, fnumber, ftaskdefineid, fstatus, fparams, ftimeout, frunbyorgid, frunbylang, fconcurrent, frunmode, fstrategy, fretrytime, fcanstop, fcreatorid, fcreatetime, fmodifierid, fmodifytime, ftasktrace) VALUES ('4RG1HC/O8Y1G', 'BIZ', 'kd.bos.cbs.plugin.archive.task.ArchiveTask', 1924580445052322816, 'bos_ARCHIVE_CLN_20250218-152856653_SKDP_S', '2145XJVI2N49', '1', '{"ArchiveSchemaId":2153051474597271552}', 0, 0, ' ', '0', '0', '1', 0, '0', 0, {ts'2025-02-18 15:29:47'}, 1924580445052322816, {ts'2025-02-18 15:29:47'}, '0');
INSERT INTO t_sch_job_n (fid, ffailnotify, fsuccessnotify, fmsgcontent, fjobprincipal, fnotifytype, fcaption, fovertime, fjobmsgreceiver, faborted) VALUES ('4RG1HC/O8Y1G', '0', '0', ' ', 0, ',,', ' ', '0', 0, '0');
INSERT INTO t_sch_job_l (fpkid, fid, flocaleid, fname, fdescription) VALUES ('4RG1HC/RY6=E', '4RG1HC/O8Y1G', 'zh_CN', '费用发票交互日志清除', ' ');



delete  from T_SCH_SCHEDULE where fid = '2153051899648038912';
delete  from T_SCH_SCHEDULE_l where fid = '2153051899648038912';

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, fcreatorid, fcreatetime, fmodifierid, fmodifytime, ftimezoneid) VALUES ('2153051899648038912', '4RG1HC/O8Y1G', {ts'2025-02-18 15:34:34'}, {ts'2099-12-31 23:59:59'}, '0 28 15 * * ?', 'bos_ARCHIVE_CLN_20250218-152856653_SKDP_S', '0', 1, '172.19.110.95', '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', null, null, '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', null, ' ', 'd', 1924580445052322816, null, 1924580445052322816, {ts'2025-02-18 15:34:34'}, 0);

INSERT INTO t_sch_schedule_l (fpkid, fid, flocaleid, fname, fdescription) VALUES ('2153051899916583936', '2153051899648038912', 'zh_CN', '费用发票交互日志清除', null);



delete  from t_cbs_archi_schema where FId = 2153051474597271552;
delete  from t_cbs_archi_schema_l where FId = 2153051474597271552;
delete  from t_cbs_archi_scheduleentry where FId = 2153051474597271552;

INSERT INTO t_cbs_archi_schema (fid, fnumber, fname, fstatus, fcreatorid, fmodifierid, fenable, fcreatetime, fmodifytime, fmasterid, fscheduleplanid, fendtime, fmovingtype, fexecutorid, fexecplan, fpreset) VALUES (2153051474597271552, 'ARCHIVE_CLN_20250218-152856653_SKDP_S', '费用发票交互日志清除', 'A', 1924580445052322816, 1924580445052322816, '1', {ts'2025-02-18 15:28:51'}, {ts'2025-02-18 15:28:51'}, 2153051474597271552, '2153051899648038912', {ts'2099-12-31 23:59:59'}, '1', 1924580445052322816, '事件将于2025-02-18 15:28:57起，每1天15时重复。
预计最近10次执行时间：
2025-02-19 15:28:00,
2025-02-20 15:28:00,
2025-02-21 15:28:00,
2025-02-22 15:28:00,
2025-02-23 1...', '0');
INSERT INTO t_cbs_archi_schema_l (fpkid, fid, flocaleid, fname) VALUES ('4RG1OFS1KF1Q', 2153051474597271552, 'zh_CN', '费用发票交互日志清除');

INSERT INTO t_cbs_archi_scheduleentry (fid, fentryid, fseq, fconfigid) VALUES (2153051474597271552, 2153052872760121344, 1, 2153050561228855296);
