DELETE FROM T_SCH_TASKDEFINE WHERE FID in ('3FIR03JYVXAO','3FIRZQNL/ZVN');
DELETE FROM T_SCH_TASKDEFINE_L WHERE FID in ('3FIR03JYVXAO','3FIRZQNL/ZVN');
DELETE FROM T_SCH_JOB WHERE FID in ('3FIR0ZMHXO6H','3FIS/9A36E6Z');
DELETE FROM T_SCH_JOB_L WHERE FID in ('3FIR0ZMHXO6H','3FIS/9A36E6Z');
DELETE FROM T_SCH_JOB_N WHERE FID in ('3FIR0ZMHXO6H','3FIS/9A36E6Z');
DELETE FROM T_SCH_SCHEDULE WHERE FID in ('3FIRTP=PS4/6','3FIS4S4UU07A');
DELETE FROM T_SCH_SCHEDULE_L WHERE FID in ('3FIRTP=PS4/6','3FIS4S4UU07A');
DELETE FROM T_SCH_SCHEDULE_N WHERE FID in ('3FIRTP=PS4/6','3FIS4S4UU07A');
DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FID in ('3FIRTP=PS4/6','3FIS4S4UU07A');

INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3FIR03JYVXAO','kd.fi.er.business.trip.task.gaode.GtripOrgTask','em','GtripOrgTask');
INSERT INTO t_sch_taskdefine(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3FIRZQNL/ZVN','kd.fi.er.business.trip.task.gaode.GtripUserTask','em','GtripUserTask');
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3FIR03JYVXAO','3FIR03K0H9HE','zh_CN','高德组织同步');
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3FIR03JYVXAO','3FIR03K0H9HF','zh_TW','高德組織同步');
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3FIRZQNL/ZVN','3FIRZQNL/XUW','zh_CN','高德人员同步');
INSERT INTO t_sch_taskdefine_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3FIRZQNL/ZVN','3FIRZQNL/XUX','zh_TW','高德人員同步');

INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('3FIR0ZMHXO6H','kd.fi.er.business.trip.task.gaode.GtripOrgTask','3FIR03JYVXAO','0',1,'BIZ','1','em_GaoDeSyncOrg_SKDJ_S','0','1',0,0,' ','0','{}',0);
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('3FIS/9A36E6Z','kd.fi.er.business.trip.task.gaode.GtripUserTask','3FIRZQNL/ZVN','0',1,'BIZ','1','em_GaoDeSyncUser_SKDP_S_SKDJ_S','0','1',0,0,' ','0','{}',0);


INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3FIR0ZMHXO6H','3FIR0ZMHXM5Q','zh_CN','费用-商旅集成-高德组织');
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3FIR0ZMHXO6H','3FIR0ZMHXM5R','zh_TW','費用-商旅集成-高德組織');
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3FIS/9A36E6Z','3FIS/9A36C66','zh_CN','费用-商旅集成-高德人员');
INSERT INTO t_sch_job_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3FIS/9A36E6Z','3FIS/9A36C67','zh_TW','費用-商旅集成-高德人員');

INSERT INTO T_SCH_JOB_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION) VALUES ('3FIR0ZMHXO6H',0,'0','0',0,' ','1',' ','调度作业通知');
INSERT INTO T_SCH_JOB_n(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION) VALUES ('3FIS/9A36E6Z',0,'0','0',0,' ','1',' ','调度作业通知');
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 31 23 * * ?','0','172.19.107.12','0','0','0','0',{ts'2099-07-31  00:00:00'},'0','0','d','0','d','0','0','0','0','事件将于2023-07-27 14:31:24起，每1天23时重复。
预计最近十次执行时间：
2023-07-27 23:31:00,
2023-07-28 23:31:00,
2023-07-29 23:31:00,
2023-07-30 23:31:00,
2023-07-31 23:31:00,
2023-08-01 23:31:00,
2023-08-02 23:31:00,
2023-08-03 23:31:00,
2023-08-04 23:31:00,
2023-08-05 23:31:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3FIR0ZMHXO6H',{ts'2023-07-27  00:00:00'},'0','0','0','3FIRTP=PS4/6','0','0','0','0','0',' ','0','em_GaoDeSyncOrg_SKDP_S','0','0',1,'0','0','0','0','0');
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 41 23 * * ?','0','172.19.107.12','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','d','0','d','0','0','0','0','事件将于2023-07-27 14:41:34起，每1天23时重复。
预计最近十次执行时间：
2023-07-27 23:41:00,
2023-07-28 23:41:00,
2023-07-29 23:41:00,
2023-07-30 23:41:00,
2023-07-31 23:41:00,
2023-08-01 23:41:00,
2023-08-02 23:41:00,
2023-08-03 23:41:00,
2023-08-04 23:41:00,
2023-08-05 23:41:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','3FIS/9A36E6Z',{ts'2023-07-27  00:00:00'},'0','0','0','3FIS4S4UU07A','0','0','0','0','0',' ','0','em_GaoDeSyncUser_SKDP_S','0','0',1,'0','0','0','0','0');

INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3FIRTP=PS4/6','3FIRTP=PS6/Z','zh_CN','费用-商旅集成-高德组织');
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3FIRTP=PS4/6','3FIRTP=PS60+','zh_TW','費用-商旅集成-高德組織');
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3FIS4S4UU07A','3FIS4S4UU+6J','zh_CN','费用-商旅集成-高德人员');
INSERT INTO t_sch_schedule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3FIS4S4UU07A','3FIS4S4UU+6K','zh_TW','費用-商旅集成-高德人員');

INSERT INTO t_sch_schedule_n(FID,FSNOTIFYTYPE,FMSGRECEIVER,FSMSGCONTENT,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('3FIRTP=PS4/6',' ',0,' ','0',0,'0','1');
INSERT INTO t_sch_schedule_n(FID,FSNOTIFYTYPE,FMSGRECEIVER,FSMSGCONTENT,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('3FIS4S4UU07A',' ',0,' ','0',0,'0','1');
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3FIRTP=PS4/6','3FIR0ZMHXO6H','3FIRTP=PS4/7',1);
INSERT INTO t_sch_schedule_entry(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3FIS4S4UU07A','3FIS/9A36E6Z','3FIS4S4UU07B',1);
