/*法定合并-清理报表编制列表临时表-系统调度预置*/

/*调度任务类名*/
DELETE FROM t_sch_taskdefine WHERE FID = '23ITYID/9P6V';
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('23ITYID/9P6V','kd.fi.bcm.business.reportlist.task.RptRecordListEntityCleanTask','cm','bcm_RptRecordListEntityCleanTask'); 

DELETE FROM t_sch_taskdefine_l WHERE FPKID = '23ITYID/=F4W';
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('23ITYID/9P6V','23ITYID/=F4W','zh_CN','清理报表编制临时表'); 

/*调度作业*/
DELETE FROM t_sch_job WHERE FID = '23IU7N7PZFCF';
INSERT INTO t_sch_job(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('23IU7N7PZFCF','kd.fi.bcm.business.reportlist.task.RptRecordListEntityCleanTask','23ITYID/9P6V','0',13466739,'BIZ','1','cm_bcm_RecordListEntityCleanTask_SKDJ_S','1','1',0,0,'zh_CN','0','{}',0); 

DELETE FROM t_sch_job_l WHERE FPKID = '23IU7N7Q+6AG';
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('23IU7N7PZFCF','23IU7N7Q+6AG','zh_CN','清理报表编制临时表'); 

/*调度计划*/
DELETE FROM t_sch_schedule WHERE FID = '23IUG09KUOQG';
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,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',' ','0','0','0','0','0 1 2 ? * 2','0','172.19.110.218','0','0','0','0',{ts'2999-12-20  00:00:00'},'0','0','w','0','d','0','0','0','0','事件将于2021-12-20 14:01:30起，
每1周的星期一2时重复。
预计最近十次执行时间：
2021-12-27 02:01:00,
2022-01-03 02:01:00,
2022-01-10 02:01:00,
2022-01-17 02:01:00,
2022-01-24 02:01:00,
2022-01-31 02:01:00,
2022-02-07 02:01:00,
2022-02-14 02:01:00,
2022-02-21 02:01:00,
2022-02-28 02:01:00','0','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','23IU7N7PZFCF',{ts'2021-12-20  00:00:00'},'0','0','0','23IUG09KUOQG','0','0','0','0','0',' ','1','cm_bcm_RecordListEntityCleanTask_SKDP_S','0','0',1,'0','0','0','0','0'); 

DELETE FROM t_sch_schedule_l WHERE FPKID = '23IUG09KVEOH';
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('23IUG09KUOQG','23IUG09KVEOH','zh_CN','清理报表编制临时表'); 

/*调度计划分录*/
DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '23IUG09KUOQH';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('23IUG09KUOQG','23IU7N7PZFCF','23IUG09KUOQH',1); 

