/*调度任务类名*/
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '49OHVXF/=0J7';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('49OHVXF/=0J7','kd.fi.bcm.business.task.ErrorLogCleanTask','cm','bcm_CleanErrorLogTask');

DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '49OHVXF/=/VZ';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('49OHVXF/=0J7','49OHVXF/=/VZ','zh_CN','清理错误日志');

/*调度作业*/
DELETE FROM T_SCH_JOB WHERE FID = '49OHZ3MSIW8/';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FRUNMODE,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FPARAMS,FRUNBYORGID) VALUES ('49OHZ3MSIW8/','kd.fi.bcm.business.task.ErrorLogCleanTask','0','49OHVXF/=0J7',1992151268210022400,'BIZ','1','cm_bcm_CleanErrorLogTask_SKDJ_S','0','1',0,0,' ','{}',100000);
DELETE FROM T_SCH_JOB_L WHERE FPKID = '49OHZ3MSIVJR';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('49OHZ3MSIW8/','49OHZ3MSIVJR','zh_CN','定时清理错误日志');

DELETE FROM T_SCH_SCHEDULE WHERE FID = '49OJ6JXJZ+GM';
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,FTWENTYSIX,FTHIRTEEN,FTWENTYSEVEN,FDESC,FAUG,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 0 0 14,28 * ?','0','172.19.108.21','0','0','0','0',{ts'2099-07-22  00:00:00'},'0','0','def','0','d','0','0','0','事件将于2024-07-22 16:16:07起，
预计最近十次执行时间：
2024-07-28 00:00:00,
2024-08-14 00:00:00,
2024-08-28 00:00:00,
2024-09-14 00:00:00,
2024-09-28 00:00:00,
2024-10-14 00:00:00,
2024-10-28 00:00:00,
2024-11-14 00:00:00,
2024-11-28 00:00:00,
2024-12-14 00:00:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','49OHZ3MSIW8/',{ts'2024-07-22  00:00:00'},'0','0','0','49OJ6JXJZ+GM','0','0','0','0','0',' ','0','cm_bcm_CleanErrorLog_SKDP_S','0','0',1,'0','0','0','0','0');

DELETE FROM t_sch_schedule_l WHERE FPKID = '49OJ6JXJYZTC';
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('49OJ6JXJZ+GM','49OJ6JXJYZTC','zh_CN','清理错误日志');

DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '49OJ6JXJZ+GN';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('49OJ6JXJZ+GM','49OHZ3MSIW8/','49OJ6JXJZ+GN',1);

IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_BD_SCHEDULECONFIG')
DELETE FROM T_BD_SCHEDULECONFIG WHERE FID = 2027006219218074624;
IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_BD_SCHEDULECONFIG')
INSERT INTO T_BD_SCHEDULECONFIG(FID,FSELBILLID,FSCHSCHEDULEID,FCANCLOSE,FMASTERID,FSTATUS,FSELBILLFILTER_TAG,FNUMBER,FNAME,FINTERFACE,FCREATETIME,FENABLE,FMODIFIERID,FEXETYPE,FMODIFYTIME,FSELBILLFILTER,FCREATORID) VALUES (2027006219218074624,'bcm_model','49OJ6JXJZ+GM','1',2027006219218074624,'A','{"filterRow":[],"forList":false}','cm_bcm_CleanErrorLog_SKDP_S','清理错误日志',' ',{ts'2024-08-28  00:00:00'},'1',13466739,'bill',{ts'2024-08-28  00:00:00'},' ',13466739);

IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_BD_SCHEDULECONFIG_L')
DELETE FROM T_BD_SCHEDULECONFIG_L WHERE FPKID = '4C+6DN7R8N8V';
IF EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_BD_SCHEDULECONFIG_L')
INSERT INTO T_BD_SCHEDULECONFIG_L(FID,FPKID,FLOCALEID,FNAME) VALUES (2027006219218074624,'4C+6DN7R8N8V','zh_CN','清理错误日志');

