--计划 sch_schedule
DELETE FROM T_SCH_SCHEDULE WHERE FID = '47JKP7HYQFBE';
INSERT INTO T_SCH_SCHEDULE(FID,FSTATUS,FDESC,FNUMBER,FPLAN,FHOST,FCREATETIME,FCYCLENUM,FMODIFIERID,FSTARTTIME,FMODIFYTIME,FJOBID,FENDTIME,FCREATORID,FREPEATMODE) VALUES ('47JKP7HYQFBE','1','事件将于2024-06-28 19:03:10起，每1天0时重复。
预计最近10次执行时间：
2024-06-29 03:39:00,
2024-06-30 03:39:00,
2024-07-01 03:39:00,
2024-07-02 03:39:00,
2024-07-03 03:39:00,
2024-07-04 03:39:00,
2024-07-05 03:39:00,
2024-07-06 03:39:00,
2024-07-07 03:39:00,
2024-07-08 03:39:00','soehrr_CycGenCollectTask','0 39 03 * * ?','172.19.146.42',{ts'2024-06-28  00:00:00'},1,1169359117375005696,{ts'2024-06-28  00:00:00'},{ts'2024-06-28  00:00:00'},'47JK384=5DUU',{ts'2099-12-31  00:00:00'},1169359117375005696,'d');
DELETE FROM T_SCH_SCHEDULE_n WHERE FID = '47JKP7HYQFBE';
INSERT INTO T_SCH_SCHEDULE_n(FID,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY,FSABORTED) VALUES ('47JKP7HYQFBE',' ',' ',0,'0',0,'0','0','0');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '47JKP7HYP04E';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('47JKP7HYQFBE','47JKP7HYP04E','zh_CN','周期方案生成采集任务调度计划');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '47JKP7HYP04F';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('47JKP7HYQFBE','47JKP7HYP04F','zh_TW','周期方案生成采集任務調度計劃');
DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '47JKP7HYQFBF';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('47JKP7HYQFBE','47JK384=5DUU','47JKP7HYQFBF',1);

DELETE FROM T_SCH_SCHEDULE WHERE FID = '47XLBRQKN49+';
INSERT INTO T_SCH_SCHEDULE(FID,FSTATUS,FDESC,FNUMBER,FPLAN,FHOST,FCREATETIME,FCYCLENUM,FMODIFIERID,FSTARTTIME,FMODIFYTIME,FJOBID,FENDTIME,FCREATORID,FREPEATMODE) VALUES ('47XLBRQKN49+','1','事件将于2024-07-02 19:51:42起，
预计最近10次执行时间：
2025-01-01 02:30:00,
2026-01-01 02:30:00,
2027-01-01 02:30:00,
2028-01-01 02:30:00,
2029-01-01 02:30:00,
2030-01-01 02:30:00,
2031-01-01 02:30:00,
2032-01-01 02:30:00,
2033-01-01 02:30:00,
2034-01-01 02:30:00','soehrr_GenNewYearDisDateTask_SKDJ_S','0 30 02 1 1 ?','172.19.146.42',{ts'2024-07-02  00:00:00'},1,1169359117375005696,{ts'2024-07-02  00:00:00'},{ts'2024-07-02  00:00:00'},'47XKXP8/EQN/',{ts'2099-12-31  00:00:00'},1169359117375005696,'def');
DELETE FROM T_SCH_SCHEDULE_n WHERE FID = '47XLBRQKN49+';
INSERT INTO T_SCH_SCHEDULE_n(FID,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY,FSABORTED) VALUES ('47XLBRQKN49+',' ',' ',0,'0',0,'0','0','0');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '47XLBRQKN4Y9';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('47XLBRQKN49+','47XLBRQKN4Y9','zh_CN','生成新一年的下发日期分录作业');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '47XLBRQKN4Y=';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('47XLBRQKN49+','47XLBRQKN4Y=','zh_TW','生成新一年的下發日期分錄作業');
DELETE FROM t_sch_schedule_entry WHERE FENTRYID = '47XLBRQKN49/';
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('47XLBRQKN49+','47XKXP8/EQN/','47XLBRQKN49/',1);

--作业 sch_job
DELETE FROM T_SCH_JOB WHERE FID = '47JK384=5DUU';
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 ('47JK384=5DUU','kd.sihc.soehrr.business.task.CycGenCollectTask','0','47JJO1D7M0PC',13466739,'BIZ','0','1','soehrr_CycCollectTaskPerDay_SKDJ_S','0','1',{ts'2024-06-28  00:00:00'},1169359117375005696,0,0,{ts'2024-06-28  00:00:00'},' ','0',1169359117375005696,'{}',0);
DELETE FROM T_SCH_JOB_n WHERE FID = '47JK384=5DUU';
INSERT INTO T_SCH_JOB_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION,FABORTED) VALUES ('47JK384=5DUU',0,'0','0',0,' ','1',' ','调度作业通知','0');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '47JK384=6U0V';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('47JK384=5DUU','47JK384=6U0V','zh_CN','周期采集方案生成采集任务');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '47JK384=6U0W';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('47JK384=5DUU','47JK384=6U0W','zh_TW','周期采集方案生成采集任務');

DELETE FROM T_SCH_JOB WHERE FID = '47XKXP8/EQN/';
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 ('47XKXP8/EQN/','kd.sihc.soehrr.business.task.GenNewYearDisDateTask','0','47XKAE/9IP+A',13466739,'BIZ','0','1','soehrr_GenNewYearDisDateTask_SKDJ_S','0','1',{ts'2024-07-02  00:00:00'},1169359117375005696,0,0,{ts'2024-07-02  00:00:00'},' ','0',1169359117375005696,'{"year":""}',0);
DELETE FROM T_SCH_JOB_n WHERE FID = '47XKXP8/EQN/';
INSERT INTO T_SCH_JOB_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION,FABORTED) VALUES ('47XKXP8/EQN/',0,'0','0',0,' ','1',' ','调度作业通知','0');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '47XKXP8/ERA9';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('47XKXP8/EQN/','47XKXP8/ERA9','zh_CN','生成新一年的下发日期分录作业');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '47XKXP8/ERA=';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('47XKXP8/EQN/','47XKXP8/ERA=','zh_TW','生成新一年的下發日期分錄作業');

--程序
DELETE FROM t_sch_taskdefine WHERE FID = '47JJO1D7M0PC';
INSERT INTO t_sch_taskdefine(FID,FCREATETIME,FMODIFIERID,FRESCHEDULED,FMODIFYTIME,FCLASSNAME,FAPPID,FCREATORID,FNUMBER) VALUES ('47JJO1D7M0PC',{ts'2024-06-28  00:00:00'},1169359117375005696,'0',{ts'2024-07-02  00:00:00'},'kd.sihc.soehrr.business.task.CycGenCollectTask','soehrr',1169359117375005696,'CycGenCollectTask');
DELETE FROM t_sch_taskdefine_L WHERE FPKID = '47JJO1D7M1CM';
INSERT INTO t_sch_taskdefine_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('47JJO1D7M0PC','47JJO1D7M1CM','zh_CN','周期方案生成采集任务');
DELETE FROM t_sch_taskdefine_L WHERE FPKID = '47JJO1D7M1CN';
INSERT INTO t_sch_taskdefine_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('47JJO1D7M0PC','47JJO1D7M1CN','zh_TW','周期方案生成采集任務');
DELETE FROM t_sch_taskdefentry WHERE FENTRYID = '47JKEL391SQT';
INSERT INTO t_sch_taskdefentry(FID,FMUST,FPARAMTYPE,FPARAMDESC,FENTRYID,FSEQ,FBASEDATAINFO,FPARAMVALUE,FPARAMNAME) VALUES ('47JJO1D7M0PC','0','0','执行的时间，为空则取当前时间','47JKEL391SQT',1,' ',' ','executeDate');
DELETE FROM t_sch_taskdefentry WHERE FENTRYID = '47XCVGKINO/W';
INSERT INTO t_sch_taskdefentry(FID,FMUST,FPARAMTYPE,FPARAMDESC,FENTRYID,FSEQ,FBASEDATAINFO,FPARAMVALUE,FPARAMNAME) VALUES ('47JJO1D7M0PC','0','0','要限制仅执行那个周期方案下的定时任务','47XCVGKINO/W',2,' ',' ','cycCollectTaskId');

DELETE FROM t_sch_taskdefine WHERE FID = '47XKAE/9IP+A';
INSERT INTO t_sch_taskdefine(FID,FCREATETIME,FMODIFIERID,FRESCHEDULED,FMODIFYTIME,FCLASSNAME,FAPPID,FCREATORID,FNUMBER) VALUES ('47XKAE/9IP+A',{ts'2024-07-02  00:00:00'},1169359117375005696,'0',{ts'2024-07-02  00:00:00'},'kd.sihc.soehrr.business.task.GenNewYearDisDateTask','soehrr',1169359117375005696,'GenNewYearDisDateTask');
DELETE FROM t_sch_taskdefine_L WHERE FPKID = '47XKAE/9IP+B';
INSERT INTO t_sch_taskdefine_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('47XKAE/9IP+A','47XKAE/9IP+B','zh_CN','生成新一年的下发日期分录任务');
DELETE FROM t_sch_taskdefine_L WHERE FPKID = '47XKAE/9IP+C';
INSERT INTO t_sch_taskdefine_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('47XKAE/9IP+A','47XKAE/9IP+C','zh_TW','生成新一年的下發日期分錄任務');
DELETE FROM t_sch_taskdefentry WHERE FENTRYID = '47XKAE/9IPNK';
INSERT INTO t_sch_taskdefentry(FID,FMUST,FPARAMTYPE,FPARAMDESC,FENTRYID,FSEQ,FBASEDATAINFO,FPARAMVALUE,FPARAMNAME) VALUES ('47XKAE/9IP+A','0','1','要生成的下发日期分录的年度','47XKAE/9IPNK',1,' ',' ','year');
