-- 用户到期预警监控方案-调度预置
-- 调度作业
DELETE FROM T_SCH_JOB WHERE FID = '1656589913564394496';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('1656589913564394496','kd.bos.service.earlywarn.EarlyWarnScheduleTask','EW_1656583562213733376','0',1,'BIZ','1','user_expirewarn_scheme_foradmin','0','1',0,0,'zh_CN','0','{"warnScheduleId":"1656583562213733376"}',0); 

-- 调度作业·多语言表
DELETE FROM T_SCH_JOB_L WHERE FID = '1656589913564394496';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1656589913564394496','3K+K/OGR954=','zh_CN','用户到期预警监控方案'); 

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

-- 调度计划
DELETE FROM T_SCH_SCHEDULE WHERE FID = '1774731857234039808';
INSERT INTO T_SCH_SCHEDULE(FID,FPLAN,FHOST,FCYCLENUM,FJOBID,FSTARTTIME,FSTATUS,FENDTIME,FNUMBER,FREPEATMODE) VALUES ('1774731857234039808','0 0 0 * * ?','10.10.163.37',1,'1656589913564394496',{ts'2023-04-05  00:00:00'},'1',{ts'2123-04-05  00:00:00'},'EW_user_expirewarn_scheme_foradmin','d'); 

-- 调度计划·多语言表
DELETE FROM T_SCH_SCHEDULE_L WHERE FID = '1774731857234039808';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1774731857234039808','1774731857326268416','zh_CN','用户到期预警监控方案'); 

-- 调度计划·拆分表

-- 调度计划 .分录表

--被禁用用户预警方案-调度预置 

-- 用户到期预警监控方案
-- 调度作业
DELETE FROM T_SCH_JOB WHERE FID = '1670395028066797568';
INSERT INTO T_SCH_JOB(FID,FTASKCLASSNAME,FTASKDEFINEID,FRUNMODE,FRUNBYUSERID,FJOBTYPE,FSTATUS,FNUMBER,FCONCURRENT,FSTRATEGY,FTIMEOUT,FRETRYTIME,FRUNBYLANG,FCANSTOP,FPARAMS,FRUNBYORGID) VALUES ('1670395028066797568','kd.bos.service.earlywarn.EarlyWarnScheduleTask','EW_1670392839747412992','0',1,'BIZ','1','user_expirewarn_scheme_foruser','0','1',0,0,'zh_CN','0','{"warnScheduleId":"1670392839747412992"}',0); 

-- 调度作业·多语言表
DELETE FROM T_SCH_JOB_L WHERE FID = '1670395028066797568';
INSERT INTO T_SCH_JOB_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1670395028066797568','3K+VDFJ42VIE','zh_CN','被禁用用户预警方案'); 

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

-- 调度计划
DELETE FROM T_SCH_SCHEDULE WHERE FID = '1670395028167460864';
INSERT INTO T_SCH_SCHEDULE(FID,FPLAN,FHOST,FCYCLENUM,FJOBID,FSTARTTIME,FSTATUS,FENDTIME,FNUMBER,FREPEATMODE) VALUES ('1670395028167460864','0 0 0 * * ?','172.19.111.91',1,'1670395028066797568',{ts'2023-04-05  00:00:00'},'1',{ts'2123-04-05  00:00:00'},'EW_user_expirewarn_scheme_foruser','d'); 

-- 调度计划·多语言表
DELETE FROM T_SCH_SCHEDULE_L WHERE FID = '1670395028167460864';
INSERT INTO T_SCH_SCHEDULE_L(FID,FPKID,FLOCALEID,FNAME) VALUES ('1670395028167460864','1670395028201014272','zh_CN','被禁用用户预警方案'); 

-- 调度计划·拆分表

-- 调度计划 .分录表
