-- 调度执行程序
DELETE FROM T_SCH_TASKDEFINE WHERE FID = '3702IMQ355NL';
INSERT INTO T_SCH_TASKDEFINE(FID,FCLASSNAME,FAPPID,FNUMBER) VALUES ('3702IMQ355NL','kd.bos.sec.user.task.UserAccountDisableTask','base','UserAccountDisableTask'); 

-- 调度执行程序·多语言表
DELETE FROM T_SCH_TASKDEFINE_L WHERE FID = '3702IMQ355NL';
INSERT INTO T_SCH_TASKDEFINE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3702IMQ355NL','3702IMQ355+B','zh_CN','人员账户禁用任务'); 

-- 调度作业
DELETE FROM T_SCH_JOB WHERE FID = '37039O29UMHZ';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('37039O29UMHZ','kd.bos.sec.user.task.UserAccountDisableTask','3702IMQ355NL','0',1,'BIZ','1','base_bos_user_AccountDisableJob_SKDJ_S','0','1',0,0,' ','0','{}',0); 

-- 调度作业·多语言表
DELETE FROM T_SCH_JOB_L WHERE FID = '37039O29UMHZ';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('37039O29UMHZ','37039O29UNVG','zh_CN','人员账号禁用调度作业'); 

-- 调度作业·拆分表
DELETE FROM T_SCH_JOB_N WHERE FID = '37039O29UMHZ';
INSERT INTO T_SCH_JOB_N(FID,FJOBPRINCIPAL,FOVERTIME,FSUCCESSNOTIFY,FJOBMSGRECEIVER,FMSGCONTENT,FFAILNOTIFY,FNOTIFYTYPE,FCAPTION) VALUES ('37039O29UMHZ',0,'0','0',0,' ','1',' ','调度作业通知'); 

-- 调度计划
DELETE FROM T_SCH_SCHEDULE WHERE FID = '3703X77S95XR';
INSERT INTO T_SCH_SCHEDULE(FID,FPLAN,FHOST,FCYCLENUM,FJOBID,FSTARTTIME,FSTATUS,FENDTIME,FNUMBER,FREPEATMODE) VALUES ('3703X77S95XR','0 0 0 * * ?','172.19.100.175',1,'37039O29UMHZ',{ts'2023-04-11  00:00:00'},'1',{ts'2999-12-31  00:00:00'},'bos_user_AccountDisableSchedule','d'); 

-- 调度计划·多语言表
DELETE FROM T_SCH_SCHEDULE_L WHERE FID = '3703X77S95XR';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('3703X77S95XR','3703X77S9799','zh_CN','用户使用时效到期自动禁用用户'); 

-- 调度计划·拆分表
DELETE FROM T_SCH_SCHEDULE_N WHERE FID = '3703X77S95XR';
INSERT INTO T_SCH_SCHEDULE_N(FID,FSNOTIFYTYPE,FSMSGCONTENT,FMSGRECEIVER,FSTIMEOUT,FSCHPRINCIPAL,FSSUCCESSNOTIFY,FSFAILNOTIFY) VALUES ('3703X77S95XR',' ',' ',0,'0',1153620127661455455,'0','1'); 

-- 调度作业 .分录表
DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '3703X77S95XS';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3703X77S95XR','37039O29UMHZ','3703X77S95XS',1); 



