DELETE FROM t_sch_taskdefine WHERE FID = '44SXWF=JWBX1';
INSERT INTO t_sch_taskdefine(FID,FCREATETIME,FMODIFIERID,FRESCHEDULED,FMODIFYTIME,FCLASSNAME,FAPPID,FCREATORID,FNUMBER) VALUES ('44SXWF=JWBX1',{ts'2024-05-28  00:00:00'},1,'0',{ts'2024-05-28  00:00:00'},'kd.sihc.soehrr.business.task.UpdateTaskStatusTask','soehrr',1,'UpdateTaskStatus');
DELETE FROM t_sch_taskdefine_L WHERE FPKID = '44SXWF=JWB7T';
INSERT INTO t_sch_taskdefine_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('44SXWF=JWBX1','44SXWF=JWB7T','zh_CN','更新数据填报任务状态定时任务');
DELETE FROM t_sch_taskdefine_L WHERE FPKID = '44SXWF=JWB7U';
INSERT INTO t_sch_taskdefine_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('44SXWF=JWBX1','44SXWF=JWB7U','zh_TW','更新數據填報任務狀態定時任務');
----调度计划
DELETE FROM T_SCH_SCHEDULE WHERE FID = '44SY6PR=QGKW';
INSERT INTO T_SCH_SCHEDULE(FID,FSTATUS,FDESC,FNUMBER,FPLAN,FHOST,FCREATETIME,FCYCLENUM,FMODIFIERID,FSTARTTIME,FMODIFYTIME,FJOBID,FENDTIME,FCREATORID,FREPEATMODE) VALUES ('44SY6PR=QGKW','1','事件将于2024-05-28 18:58:32起，每1天2时重复。
预计最近10次执行时间：
2024-05-29 02:58:00,
2024-05-30 02:58:00,
2024-05-31 02:58:00,
2024-06-01 02:58:00,
2024-06-02 02:58:00,
2024-06-03 02:58:00,
2024-06-04 02:58:00,
2024-06-05 02:58:00,
2024-06-06 02:58:00,
2024-06-07 02:58:00','UpdateTaskStatus','0 58 2 * * ?','172.19.144.27',{ts'2024-05-28  00:00:00'},1,1,{ts'2024-05-28  00:00:00'},{ts'2024-05-28  00:00:00'},'44SY1RKWZUP=',{ts'2099-12-31  00:00:00'},1,'d');
DELETE FROM T_SCH_SCHEDULE_n WHERE FID = '44SY6PR=QGKW';
INSERT INTO T_SCH_SCHEDULE_n(FID,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY,FSABORTED) VALUES ('44SY6PR=QGKW',' ',' ',0,'0',1,'0','0','0');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '44SY6PR=QH95';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('44SY6PR=QGKW','44SY6PR=QH95','zh_CN','更新数据填报任务状态');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '44SY6PR=QH96';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('44SY6PR=QGKW','44SY6PR=QH96','zh_TW','更新數據填報任務狀態');
DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '44SY6PR=QGKX';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('44SY6PR=QGKW','44SY1RKWZUP=','44SY6PR=QGKX',1);
----调度作业
DELETE FROM T_SCH_JOB WHERE FID = '44SY1RKWZUP=';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FRUNMODE,FTASKDEFINEID,FRUNBYUSERID,FJOBTYPE,FTASKTRACE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FCREATETIME,FMODIFIERID,FTIMEOUT,FRETRYTIME,FMODIFYTIME,FRUNBYLANG,FCANSTOP,FCREATORID,FPARAMS,FRUNBYORGID) VALUES ('44SY1RKWZUP=','kd.sihc.soehrr.business.task.UpdateTaskStatusTask','0','44SXWF=JWBX1',1,'BIZ','0','1','soehrr_UpdateTaskStatus_SKDJ_S','0','1',{ts'2024-05-28  00:00:00'},1,0,0,{ts'2024-06-07  00:00:00'},'zh_CN','0',1,'{}',0);
DELETE FROM T_SCH_JOB_n WHERE FID = '44SY1RKWZUP=';
INSERT INTO T_SCH_JOB_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION,FABORTED) VALUES ('44SY1RKWZUP=',1,'0','0',0,' ','1',' ','调度作业通知','0');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '44SY1RKWZU00';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('44SY1RKWZUP=','44SY1RKWZU00','zh_CN','更新待生效填报任务状态');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '44SY1RKWZU01';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('44SY1RKWZUP=','44SY1RKWZU01','zh_TW','更新待生效填報任務狀態');


