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

-- 调度执行程序·多语言表
DELETE FROM T_SCH_TASKDEFINE_l WHERE FID = '3BMYO9CWM78M';
INSERT INTO T_SCH_TASKDEFINE_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3BMYO9CWM78M','3BMYO9CWLHN3','zh_CN','人员个人信息清除任务'); 

-- 调度作业
DELETE FROM T_SCH_JOB WHERE FID = '3BMYS+ZHTJSI';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('3BMYS+ZHTJSI','kd.bos.sec.user.task.UserInfoCleanTask','3BMYO9CWM78M','0',1,'BIZ','1','base_bos_user_InfoCleanJob_SKDJ_S','0','1',0,0,' ','0','{}',0); 

-- 调度作业·多语言表
DELETE FROM T_SCH_JOB_l WHERE FID = '3BMYS+ZHTJSI';
INSERT INTO T_SCH_JOB_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3BMYS+ZHTJSI','3BMYS+ZHSV6/','zh_CN','人员个人信息清除作业');  

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

-- 调度计划
DELETE FROM T_SCH_SCHEDULE WHERE FID = '3BMYZDJWUAZJ';
INSERT INTO T_SCH_SCHEDULE(FID,FPLAN,FHOST,FCYCLENUM,FJOBID,FSTARTTIME,FSTATUS,FENDTIME,FNUMBER,FREPEATMODE) VALUES ('3BMYZDJWUAZJ','0 0 0 * * ?','172.19.111.91',1,'3BMYS+ZHTJSI',{ts'2023-06-13  00:00:00'},'1',{ts'2999-12-31  00:00:00'},'base_bos_user_InfoCleanSchedule_SKDP_S','d'); 

-- 调度计划·多语言表
DELETE FROM T_SCH_SCHEDULE_l WHERE FID = '3BMYZDJWUAZJ';
INSERT INTO T_SCH_SCHEDULE_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3BMYZDJWUAZJ','3BMYZDJWTMC0','zh_CN','人员个人信息清除调度计划'); 

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

-- 调度作业 .分录表
DELETE FROM T_SCH_SCHEDULE_ENTRY WHERE FENTRYID = '3BMYZDJWUAZK';
INSERT INTO T_SCH_SCHEDULE_ENTRY(FID,FJOBNUMBER,FENTRYID,FSEQ) VALUES ('3BMYZDJWUAZJ','3BMYS+ZHTJSI','3BMYZDJWUAZK',1); 