
/* 业务数据提报分录表明细数据升级定时任务-预置数据*/
/* 调度任务类*/
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '2XZ6M/FPPD0V';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('2XZ6M/FPPD0V','kd.swc.hpdi.business.task.BizDataBillDetailUpdateTask','hpdi','hpdi_bizdatabilldetailupdate_task');

DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '2XZ6M/G27+3W';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2XZ6M/FPPD0V','2XZ6M/G27+3W','zh_CN','业务数据提报明细表旧数据升级任务');

/* 调度作业*/
DELETE FROM T_SCH_JOB WHERE FID = '2XZLLOYXK/PR';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FPARAMS,FRUNBYORGID) VALUES ('2XZLLOYXK/PR','kd.swc.hpdi.business.task.BizDataBillDetailUpdateTask','2XZ6M/FPPD0V','0',1158705950345960448,'BIZ','1','hpdi_bizdatabilldetailupdatetask_SKDJ_S','0','1',0,0,' ','{}',0);

DELETE FROM T_SCH_JOB_L WHERE FPKID = '2XZLLOZ/6HL=';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2XZLLOYXK/PR','2XZLLOZ/6HL=','zh_CN','业务数据提报明细表旧数据升级作业');

/* 调度计划*/
DELETE FROM T_SCH_SCHEDULE WHERE FID = '2XZLY8IV+3ON';
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,FFEB,FJUN) VALUES ('0','0','0','0',' ','0','0','0','0','0 0/10 * * * ?','0','172.19.105.163','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','mi','0','d','0','0','0','0','事件将于2022-12-08 14:19:46起，每10分钟重复。
预计最近十次执行时间：
2022-12-08 14:20:00,
2022-12-08 14:30:00,
2022-12-08 14:40:00,
2022-12-08 14:50:00,
2022-12-08 15:00:00,
2022-12-08 15:10:00,
2022-12-08 15:20:00,
2022-12-08 15:30:00,
2022-12-08 15:40:00,
2022-12-08 15:50:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2XZLLOYXK/PR',{ts'2022-12-08  00:00:00'},'0','0','0','2XZLY8IV+3ON','0','0','0','0','0',' ','1','hpdi_bizdatabilldetailupdatetask_plan','0','0',10,'0','0','0','0','0');

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2XZLY8IV+6CO';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2XZLY8IV+3ON','2XZLY8IV+6CO','zh_CN','业务数据提报明细表旧数据升级计划');

DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '2XZLY8IV+3OO';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('2XZLY8IV+3ON','2XZLLOYXK/PR','2XZLY8IV+3OO',1);

