/** 预置后台定时计划，自动清理BOTP删除关联关系记录日志 **/

DELETE FROM T_SCH_TASKDEFINE WHERE FID = '3W9+KN+NZVGK';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3W9+KN+NZVGK','kd.bos.schedule.BillLkDoDelStatusBTask','ctsy','BillLkDoDelStatusBTask');

DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '3W9+KN+OCOUP';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3W9+KN+NZVGK','3W9+KN+OCOUP','zh_CN','关联关系记录删除状态为1的处理类');
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '3W9+KN+OCOUQ';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3W9+KN+NZVGK','3W9+KN+OCOUQ','zh_TW','關聯關係記錄刪除狀態為1的處理類');



DELETE FROM T_SCH_JOB WHERE FID = '3W90QT5/N20J';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FCONCURRENT,FNUMBER,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FRUNBYORGID,FPARAMS) VALUES ('3W90QT5/N20J','kd.bos.schedule.BillLkDoStatusCTask','3W9+KN+NZVGK','0',1610253068350507008,'BIZ','1','0','ctsy_ctbotp_BillLkDoDelStatusBTask_SKDJ_S','1',0,0,' ',0,'{"circleNumber":"50","startMinutes":"10","endMinutes":"90","batchCount":"2000"}');


DELETE FROM T_SCH_JOB_L WHERE FPKID = '3W90QT50VTJI';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3W90QT5/N20J','3W90QT50VTJI','zh_CN','处理删除状态为1的关联关系记录');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '3W90QT50VTJJ';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3W90QT5/N20J','3W90QT50VTJJ','zh_TW','處理刪除狀態為1的關聯關係記錄');



DELETE FROM T_SCH_SCHEDULE WHERE FID = '3W91A=KC6T/2';
INSERT INTO T_SCH_SCHEDULE(FTWENTY,FFIVE,FELEVEN,FNINE,FNO,FSUN,FTWO,FEIGHT,FNOV,FPLAN,FWED,FHOST,FTWENTYTWO,FFOUR,FMAR,FSEP,FENDTIME,FSIX,FREPEATMODE,FMAY,FTHIRTYONE,FBYDAYORWEEK,FTWENTYSEVEN,FTWENTYSIX,FTHIRTEEN,FAUG,FDESC,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',NULL,'0','0','0','0','0 0/20 0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23 * * ?','0','172.19.68.89','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','mi','0','0',NULL,'0','0','0','0','事件将于2024-01-31 11:08:25起，0时,1时,2时,3时,4时,5时,6时,7时,8时,9时,10时,11时,12时,13时,14时,15时,16时,17时,18时,19时,20时,21时,22时,23时每20分钟重复。','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3W90QT5/N20J',{ts'2024-01-31  00:00:00'},'0','0','0','3W91A=KC6T/2','0','0','0','0','0',NULL,'1','ctsy_ctbotp_BillLkDoDelStatusBTask_SKDP_S','0','0',20,'0','0','0','0','0');




DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '3W91A=KB+1H4';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3W91A=KC6T/2','3W91A=KB+1H4','zh_CN','处理删除状态为1的关联关系记录');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '3W91A=KB+1H5';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3W91A=KC6T/2','3W91A=KB+1H5','zh_TW','處理刪除狀態為1的關聯關係記錄');


/**  **/


