/* 调度任务类名 */
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '2RQO5GE5FBU9';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('2RQO5GE5FBU9','kd.swc.hpdi.business.task.BizDataBillUpdateTask','hpdi','hpdi_bizdatabillupdate_task');

DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '2RQO5GE5FCHI';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2RQO5GE5FBU9','2RQO5GE5FCHI','zh_CN','业务数据提报单据更新');
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '2RQO5GE5FCHJ';
--INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2RQO5GE5FBU9','2RQO5GE5FCHJ','zh_TW','業務數據提報單據更新');

/* 调度作业 */
DELETE FROM T_SCH_JOB WHERE FID = '2RQOOIGCY1Z8';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FPARAMS,FRUNBYORGID) VALUES ('2RQOOIGCY1Z8','kd.swc.hpdi.business.task.BizDataBillUpdateTask','2RQO5GE5FBU9','0',13466739,'BIZ','1','hpdi_bizdatabillupdatetask_SKDJ_S','0','1',0,0,' ','{}',0);

DELETE FROM T_SCH_JOB_L WHERE FPKID = '2RQOOIGCY9C1';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2RQOOIGCY1Z8','2RQOOIGCY9C1','zh_CN','业务数据提报单据更新作业');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '2RQOOIGCY9C2';
--INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2RQOOIGCY1Z8','2RQOOIGCY9C2','zh_TW','業務數據提報單據更新作業');

/* 调度计划 */
DELETE FROM T_SCH_SCHEDULE WHERE FID = '2RQP20O8AI/W';
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 22 4 * * ?','0','172.19.112.64','0','0','0','0',{ts'2999-09-30  00:00:00'},'0','0','d','0','d','0','0','0','0','事件将于2022-09-29 15:22:21起，每1天4时重复。
预计最近十次执行时间：
2022-09-30 04:22:00,
2022-10-01 04:22:00,
2022-10-02 04:22:00,
2022-10-03 04:22:00,
2022-10-04 04:22:00,
2022-10-05 04:22:00,
2022-10-06 04:22:00,
2022-10-07 04:22:00,
2022-10-08 04:22:00,
2022-10-09 04:22:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2RQOOIGCY1Z8',{ts'2022-09-29  00:00:00'},'0','0','0','2RQP20O8AI/W','0','0','0','0','0',' ','1','hpdi_bizdatabillupdatetask','0','0',1,'0','0','0','0','0');

DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2RQP20O8APEP';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2RQP20O8AI/W','2RQP20O8APEP','zh_CN','业务数据提报单据更新');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2RQP20O8APEQ';
--INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('2RQP20O8AI/W','2RQP20O8APEQ','zh_TW','業務數據提報單據更新');

DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '2RQP20O8AI/X';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('2RQP20O8AI/W','2RQOOIGCY1Z8','2RQP20O8AI/X',1);
