/*  管控日志归档-定时任务  */
/* BDCtrlLogArchiveTask 执行程序 */
DELETE FROM t_sch_job WHERE FID = '3H77O8TVG=D5';
INSERT INTO t_sch_job(FID,FTASKCLASSNAME,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FTASKDEFINEID,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('3H77O8TVG=D5','kd.bos.bd.log.timetask.BDCtrlLogArchiveTask','0',1,'BIZ','1','bos_BDCtrlLogArchiveTask_SKDJ_S','0','1',0,'3H774U6=1G/1',0,' ','0','{}',0);

DELETE FROM t_sch_job_l WHERE FID = '3H77O8TVG=D5';
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3H77O8TVG=D5','3H77O8TZ2Q8Y','zh_CN','管控日志归档-定时任务');
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3H77O8TVG=D5','3H77O8TZ2Q8Z','zh_TW','管控日誌歸檔-定時任務');

/* BDCtrlLogArchiveTask 调度作业 */
DELETE FROM t_sch_taskdefine WHERE FID = '3H774U6=1G/1';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3H774U6=1G/1','kd.bos.bd.log.timetask.BDCtrlLogArchiveTask','bos','BDCtrlLogArchiveTask');

DELETE FROM t_sch_taskdefine_l WHERE FID = '3H774U6=1G/1';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3H774U6=1G/1','3H774U6=1GOA','zh_CN','管控日志归档-定时任务');
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3H774U6=1G/1','3H774U6=1GOB','zh_TW','管控日誌歸檔-定時任務');

/* BDCtrlLogArchiveTask 调度计划 */
DELETE FROM t_sch_schedule WHERE FID = '3H78SFQ8SBC0';
INSERT INTO t_sch_schedule(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FSUN,FTWO,FFIFTEEN,FDESC,FEIGHT,FNOV,FPLAN,FWED,FHOST,FFOUR,FMAR,FENDTIME,FSIX,FMAY,FREPEATMODE,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSIX,FTHIRTEEN,FAUG,FTWENTYONE,FBYWEEK,FTUES,FSEVENTEEN,FTWENTYFOUR,FTHIRTY,FTHREE,FFOURTEEN,FJAN,FSEVEN,FNINETEEN,FTHUR,FTEN,FFRI,FJOBID,FSTARTTIME,FOCT,FMON,FAPR,FSIXTEEN,FID,FSAT,FONE,FTWENTYEIGHT,FTWENTYTHREE,FTWELVE,FNOWEEK,FSTATUS,FNUMBER,FTWENTYTWO,FSEP,FTWENTYFIVE,FEIGHTEEN,FCYCLENUM,FTWENTYNINE,FJUL,FTWENTYSEVEN,FDEC,FJUN,FFEB) VALUES ('0','0','0','0',NULL,'0','0','0',' ','0','0','0 0 0 * * ?','0','172.19.78.218','0','0',{ts'2099-12-31  00:00:00'},'0','0','d','0',NULL,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3H77O8TVG=D5',{ts'2023-08-15  00:00:00'},'0','0','0','0','3H78SFQ8SBC0','0','0','0','0','0',NULL,'1','BDCtrlLogArchiveTask','0','0','0','0',1,'0','0','0','0','0','0');

DELETE FROM t_sch_schedule_l WHERE FID = '3H78SFQ8SBC0';
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3H78SFQ8SBC0','3H78SFQ8SAOS','zh_CN','管控日志归档-定时任务');
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3H78SFQ8SBC0','3H78SFQ8SAOT','zh_TW','管控日誌歸檔-定時任務');


/*  管控日志归档清除-定时任务  */
/* BDCtrlLogArchiveCleanTask 执行程序 */
DELETE FROM t_sch_job WHERE FID = '3H7ZS59VGSXY';
INSERT INTO t_sch_job(FID,FTASKCLASSNAME,FRUNMODE,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('3H7ZS59VGSXY','kd.bos.bd.log.timetask.BDCtrlLogArchiveCleanTask','0','3H7ZMXOXSI8P',1,'BIZ','1','bos_BDCtrlLogArchiveCleanTask_SKDJ_S','0','1',0,0,' ','0','{}',0);

DELETE FROM t_sch_job_l WHERE FID = '3H7ZS59VGSXY';
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3H7ZS59VGSXY','3H7ZS59VGTL6','zh_CN','管控日志归档清除-定时任务');
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3H7ZS59VGSXY','3H7ZS59VGTL7','zh_TW','管控日誌歸檔清除-定時任務');

/* BDCtrlLogArchiveCleanTask 调度作业 */
DELETE FROM t_sch_taskdefine WHERE FID = '3H7ZMXOXSI8P';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3H7ZMXOXSI8P','kd.bos.bd.log.timetask.BDCtrlLogArchiveCleanTask','bos','BDCtrlLogArchiveCleanTask');

DELETE FROM t_sch_taskdefine_l WHERE FID = '3H7ZMXOXSI8P';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3H7ZMXOXSI8P','3H7ZMXP30CA+','zh_CN','管控日志归档清理-定时任务');
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3H7ZMXOXSI8P','3H7ZMXP30CA/','zh_TW','管控日誌歸檔清理-定時任務');

/* BDCtrlLogArchiveCleanTask 调度计划 */
DELETE FROM t_sch_schedule WHERE FID = '3H7ZWDVTYW8Y';
INSERT INTO t_sch_schedule(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FSUN,FTWO,FFIFTEEN,FDESC,FEIGHT,FNOV,FPLAN,FWED,FHOST,FFOUR,FMAR,FENDTIME,FSIX,FMAY,FREPEATMODE,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSIX,FTHIRTEEN,FAUG,FTWENTYONE,FBYWEEK,FTUES,FSEVENTEEN,FTWENTYFOUR,FTHIRTY,FTHREE,FFOURTEEN,FJAN,FSEVEN,FNINETEEN,FTHUR,FTEN,FFRI,FJOBID,FSTARTTIME,FOCT,FMON,FAPR,FSIXTEEN,FID,FSAT,FONE,FTWENTYEIGHT,FTWENTYTHREE,FTWELVE,FNOWEEK,FSTATUS,FNUMBER,FTWENTYTWO,FSEP,FTWENTYFIVE,FEIGHTEEN,FCYCLENUM,FTWENTYNINE,FJUL,FTWENTYSEVEN,FDEC,FJUN,FFEB) VALUES ('0','0','0','0',NULL,'0','0','0',' ','0','0','0 0 0 * * ?','0','172.19.78.218','0','0',{ts'2099-12-31  00:00:00'},'0','0','d','0',NULL,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3H7ZS59VGSXY',{ts'2023-08-15  00:00:00'},'0','0','0','0','3H7ZWDVTYW8Y','0','0','0','0','0',NULL,'1','BDCtrlLogArchiveCleanTask','0','0','0','0',1,'0','0','0','0','0','0');

DELETE FROM t_sch_schedule_l WHERE FID = '3H7ZWDVTYW8Y';
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3H7ZWDVTYW8Y','3H7ZWDVTYWY7','zh_CN','管控日志归档清除-定时任务');
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3H7ZWDVTYW8Y','3H7ZWDVTYWY8','zh_TW','管控日誌歸檔清除-定時任務');
