DELETE FROM T_SCH_JOB WHERE FID = '473OXS49A8GY';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('473OXS49A8GY','kd.fi.er.business.trip.task.tripboards.OrderSummaryTask','473OWL1LX/+6','0',1925266062056993792,'BIZ','1','em_tripsummary_SKDJ_S','0','1',0,0,' ','0','{}',1880481697179488256);
DELETE FROM T_SCH_JOB_L WHERE FPKID = '473OXS49A74E';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('473OXS49A8GY','473OXS49A74E','zh_CN','商旅看板_汇总');
DELETE FROM T_SCH_JOB_N WHERE FID = '473OXS49A8GY';
INSERT INTO T_SCH_JOB_N(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION) VALUES ('473OXS49A8GY',0,'0','0',0,' ','1',' ','调度作业通知');
DELETE FROM T_SCH_SCHEDULE WHERE FID = '473OZ73E4FSI';
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',NULL,'0','0','0','0','0 15 23 * * ?','0','172.19.79.160','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','d','0',NULL,'0','0','0','0','事件将于2024-06-23 22:15:33起，每1天23时重复。
预计最近10次执行时间：
2024-07-17 23:15:00,
2024-07-18 23:15:00,
2024-07-19 23:15:00,
2024-07-20 23:15:00,
2024-07-21 23:15:00,
2024-07-22 23:15:00,
2024-07-23 23:15:00,
2024-07-24 23:15:00,
2024-07-25 23:15:00,
2024-07-26 23:15:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','473OXS49A8GY',{ts'2024-06-23  00:00:00'},'0','0','0','473OZ73E4FSI','0','0','0','0','0',NULL,'0','em_tripsummary_SKDJ_S_SKDP_S','0','0',1,'0','0','0','0','0');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '473OZ73E4EF0';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('473OZ73E4FSI','473OZ73E4EF0','zh_CN','商旅看板_汇总');
DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '473OZ73E4FSJ';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('473OZ73E4FSI','473OXS49A8GY','473OZ73E4FSJ',1);
DELETE FROM T_SCH_SCHEDULE_N WHERE FID = '473OZ73E4FSI';
INSERT INTO T_SCH_SCHEDULE_N(FID,FSNOTIFYTYPE,FMSGRECEIVER,FSMSGCONTENT,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('473OZ73E4FSI',',,',0,' ','0',0,'0','0');
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '473OWL1LX/+6';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('473OWL1LX/+6','kd.fi.er.business.trip.task.tripboards.OrderSummaryTask','em','Trip_Summary');
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '473OWL1LWZMO';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('473OWL1LX/+6','473OWL1LWZMO','zh_CN','商旅汇总');

-- 组织树构造
DELETE FROM T_SCH_JOB WHERE FID = '4974NQQ43BT/';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('4974NQQ43BT/','kd.fi.er.business.trip.task.tripboards.BuildOrgNodeTask','4974G981BCTP','0',13466739,'BIZ','1','em_orgbuild_SKDJ_S','0','1',0,0,' ','0','{}',0);
DELETE FROM T_SCH_JOB_L WHERE FPKID = '4974NQQ43CG9';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('4974NQQ43BT/','4974NQQ43CG9','zh_CN','商旅看板-组织树构造');
DELETE FROM T_SCH_JOB_N WHERE FID = '4974NQQ43BT/';
INSERT INTO T_SCH_JOB_N(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION) VALUES ('4974NQQ43BT/',0,'0','0',0,' ','1',' ','调度作业通知');
DELETE FROM T_SCH_SCHEDULE WHERE FID = '4974OMEV3LKQ';
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',NULL,'0','0','0','0','0 13 23 ? * 1','0','172.19.79.160','0','0','0','0',{ts'2099-12-31  00:00:00'},'0','0','w','0',NULL,'0','0','0','0','事件将于2024-07-17 09:13:35起，每1周的星期日23时重复。
预计最近10次执行时间：
2024-07-21 23:13:00,
2024-07-28 23:13:00,
2024-08-04 23:13:00,
2024-08-11 23:13:00,
2024-08-18 23:13:00,
2024-08-25 23:13:00,
2024-09-01 23:13:00,
2024-09-08 23:13:00,
2024-09-15 23:13:00,
2024-09-22 23:13:00','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','4974NQQ43BT/',{ts'2024-07-17  00:00:00'},'0','0','0','4974OMEV3LKQ','0','0','0','0','0',NULL,'0','em_triporgbulid_SKDJ_S_SKDP_S','0','0',1,'0','0','0','0','0');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '4974OMEV3M9/';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('4974OMEV3LKQ','4974OMEV3M9/','zh_CN','商旅看板-组织树构造');
DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '4974OMEV3LKR';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('4974OMEV3LKQ','4974NQQ43BT/','4974OMEV3LKR',1);
DELETE FROM T_SCH_SCHEDULE_N WHERE FID = '4974OMEV3LKQ';
INSERT INTO T_SCH_SCHEDULE_N(FID,FSNOTIFYTYPE,FMSGRECEIVER,FSMSGCONTENT,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('4974OMEV3LKQ',' ',0,' ','0',0,'0','0');
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '4974G981BCTP';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('4974G981BCTP','kd.fi.er.business.trip.task.tripboards.BuildOrgNodeTask','em','Org_build');
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '4974G981BC4F';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('4974G981BCTP','4974G981BC4F','zh_CN','组织树构造');



