/*调度任务类名*/
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '2QUWMBDTXIMT';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FNUMBER,FAPPID) VALUES('2QUWMBDTXIMT','kd.hr.haos.business.task.HaosUpdateDataTask','HaosUpdateDataTask','haos');
DELETE FROM T_SCH_TASKDEFINE_L WHERE FPKID = '2QUWMBDTZCO8';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FLOCALEID,FPKID,FNAME) VALUES('2QUWMBDTXIMT','zh_CN','2QUWMBDTZCO8','组织数据升级的调动任务');
/*调度作业*/
DELETE FROM T_SCH_JOB WHERE FID = '2QUY/WU5HA8X';
INSERT INTO T_SCH_JOB(FID,FNUMBER,FJOBTYPE,FPARAMS,FTASKDEFINEID,FTASKCLASSNAME,FRUNBYORGID,FRUNBYLANG,FRUNBYUSERID,FRUNMODE,FTIMEOUT,FRETRYTIME,FSTRATEGY,FCONCURRENT,FCANSTOP,FSTATUS) VALUES('2QUY/WU5HA8X','haos_updateOrgTask_SKDJ_S','BIZ','{"updateChangeTranSum":"0","updateChangeOperDetail":"0","updateChangeTranDetail":"0"}','2QUWMBDTXIMT','kd.hr.haos.business.task.HaosUpdateDataTask',0,'zh_CN',1,'0',0,0,'1','0','0','1');
DELETE FROM T_SCH_JOB_L WHERE FPKID = '2QUY/WU5HC9O';
INSERT INTO T_SCH_JOB_L(FID,FLOCALEID,FPKID,FNAME) VALUES('2QUY/WU5HA8X','zh_CN','2QUY/WU5HC9O','组织相关数据升级');
DELETE FROM T_SCH_JOB_N WHERE FID = '2QUY/WU5HA8X';
INSERT INTO T_SCH_JOB_N(FID,FJOBPRINCIPAL,FFAILNOTIFY,FSUCCESSNOTIFY,FCAPTION,FNOTIFYTYPE,FMSGCONTENT,FOVERTIME,FJOBMSGRECEIVER) VALUES('2QUY/WU5HA8X',0,'1','0','调度作业通知',' ',' ','0',0);
/*调度作业参数*/
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '2QUYA30F/M/X';
INSERT INTO T_SCH_JOBPARAMS(FENTRYID,FSEQ,FPARAMNAME,FPARAMVALUE,FMUST,FPARAMTYPE,FBASEDATAINFO,FID) VALUES('2QUYA30F/M/X',1,'updateChangeTranSum','0','1','0',' ','2QUY/WU5HA8X');
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '2QUYA30F/M/Y';
INSERT INTO T_SCH_JOBPARAMS(FENTRYID,FSEQ,FPARAMNAME,FPARAMVALUE,FMUST,FPARAMTYPE,FBASEDATAINFO,FID) VALUES('2QUYA30F/M/Y',2,'updateChangeTranDetail','0','1','0',' ','2QUY/WU5HA8X');
DELETE FROM T_SCH_JOBPARAMS WHERE FENTRYID = '2QUYA30F/M/Z';
INSERT INTO T_SCH_JOBPARAMS(FENTRYID,FSEQ,FPARAMNAME,FPARAMVALUE,FMUST,FPARAMTYPE,FBASEDATAINFO,FID) VALUES('2QUYA30F/M/Z',3,'updateChangeOperDetail','0','1','0',' ','2QUY/WU5HA8X');
/*调度计划*/
DELETE FROM T_SCH_SCHEDULE WHERE FID = '2QUYKY52496G';
INSERT INTO T_SCH_SCHEDULE(FID,FNUMBER,FJOBID,FSTARTTIME,FENDTIME,FPLAN,FREPEATMODE,FCYCLENUM,FONE,FTWO,FTHIRTY,FTWENTYNINE,FTWENTYEIGHT,FTWENTYSEVEN,FTWENTYSIX,FTWENTYFIVE,FTWENTYFOUR,FTWENTYTHREE,FTWENTYTWO,FTWENTYONE,FTWENTY,FNINETEEN,FEIGHTEEN,FSEVENTEEN,FSIXTEEN,FFIFTEEN,FFOURTEEN,FTHIRTEEN,FTWELVE,FELEVEN,FTEN,FNINE,FEIGHT,FSEVEN,FSIX,FFIVE,FFOUR,FTHREE,FJAN,FDEC,FNOV,FOCT,FSEP,FAUG,FJUL,FJUN,FMAY,FAPR,FMAR,FFEB,FBYWEEK,FBYDAYORWEEK,FHOST,FDESC,FSUN,FMON,FTUES,FWED,FTHUR,FFRI,FSAT,FNO,FNOWEEK,FTHIRTYONE,FSTATUS) VALUES('2QUYKY52496G','haos_updateOrgTask_SKDP_S','2QUY/WU5HA8X',{ts'2022-09-19 15:05:03'},{ts'2999-03-25 10:54:05'},'0 5 15 19 9 ? 2022','n',1,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','d','172.19.75.78','事件不重复','0','0','0','0','0','0','0',' ',' ','0','1');
DELETE FROM T_SCH_SCHEDULE_L WHERE FPKID = '2QUYKY52475P';
INSERT INTO T_SCH_SCHEDULE_L(FID,FLOCALEID,FPKID,FNAME) VALUES('2QUYKY52496G','zh_CN','2QUYKY52475P','组织相关数据升级');
DELETE FROM T_SCH_SCHEDULE_N WHERE FID = '2QUYKY52496G';
INSERT INTO T_SCH_SCHEDULE_N(FID,FSCHPRINCIPAL,FSFAILNOTIFY,FSSUCCESSNOTIFY,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT) VALUES('2QUYKY52496G',0,'1','0',' ',' ',0,'0');
DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '2QUYKY52496H';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FENTRYID,FSEQ,FJOBNUMBER,FID) VALUES('2QUYKY52496H',1,'2QUY/WU5HA8X','2QUYKY52496G');

