AdminEAP框架-基于AdminLTE的任务调度器(支持集群)

AdminEAP

AdminEAP为是基于AdminLTE改造的后台管理框架,包含了组件集成、CURD增删改查、系统工具、工作流、系统权限与安全等基本的系统管理功能和各种交互demo,项目源码已经在Github上开源,并部署到阿里云。

Github : https://github.com/bill1012/AdminEAP

AdminEAP 官网: http://www.admineap.com

本文介绍在AdminEAP框架中,集成Quartz,来进行自动任务管理,以便随时监控系统中当前的任务,并能在线新增任务、暂停任务、恢复任务、删除任务、立即运行任务。

在quartz中一个trigger可对应一个job,job可以有多个trigger,trigger分为CronTrigger与SimpleTrigger;CronTrigger通过Cron表达式配置定时任务,SimpleTrigger则配置一些简单重复的定时任务。

quartz分为基于内存的方式和基于数据库的方式,在本文中使用了基于数据库的方式(支持集群)。这样提高了系统的可靠性,在配置时,请保持应用服务器的时钟同步。

关于具体集成quartz的步骤,可参考AdminEAP源码,也可参考本人之前的博客:

以下为实现的任务调度管理器:

任务调度器

使用说明

AdminEAP框架使用mysql数据库,所以要在mysql中创建quartz所需要的表。

1、mysql创建表结构

    --  
    -- A hint submitted by a user: Oracle DB MUST be created as "shared" and the   
    -- job_queue_processes parameter  must be greater than 2  
    -- However, these settings are pretty much standard after any  
    -- Oracle install, so most users need not worry about this.  
    --  
    -- Many other users (including the primary author of Quartz) have had success  
    -- runing in dedicated mode, so only consider the above as a hint ;-)  
    --  

    delete from qrtz_fired_triggers;  
    delete from qrtz_simple_triggers;  
    delete from qrtz_simprop_triggers;  
    delete from qrtz_cron_triggers;  
    delete from qrtz_blob_triggers;  
    delete from qrtz_triggers;  
    delete from qrtz_job_details;  
    delete from qrtz_calendars;  
    delete from qrtz_paused_trigger_grps;  
    delete from qrtz_locks;  
    delete from qrtz_scheduler_state;  

    drop table qrtz_calendars;  
    drop table qrtz_fired_triggers;  
    drop table qrtz_blob_triggers;  
    drop table qrtz_cron_triggers;  
    drop table qrtz_simple_triggers;  
    drop table qrtz_simprop_triggers;  
    drop table qrtz_triggers;  
    drop table qrtz_job_details;  
    drop table qrtz_paused_trigger_grps;  
    drop table qrtz_locks;  
    drop table qrtz_scheduler_state;  

    -- 存储每一个已配置的 Job 的详细信息  
    CREATE TABLE qrtz_job_details  
      (  
        SCHED_NAME VARCHAR2(120) NOT NULL,  
        JOB_NAME  VARCHAR2(200) NOT NULL,  
        JOB_GROUP VARCHAR2(200) NOT NULL,  
        DESCRIPTION VARCHAR2(250) NULL,  
        JOB_CLASS_NAME   VARCHAR2(250) NOT NULL,   
        IS_DURABLE VARCHAR2(1) NOT NULL,  
        IS_NONCONCURRENT VARCHAR2(1) NOT NULL,  
        IS_UPDATE_DATA VARCHAR2(1) NOT NULL,  
        REQUESTS_RECOVERY VARCHAR2(1) NOT NULL,  
        JOB_DATA BLOB NULL,  
        CONSTRAINT QRTZ_JOB_DETAILS_PK PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)  
    );  
    --  存储已配置的 Trigger 的信息  
    CREATE TABLE qrtz_triggers  
      (  
        SCHED_NAME VARCHAR2(120) NOT NULL,  
        TRIGGER_NAME VARCHAR2(200) NOT NULL,  
        TRIGGER_GROUP VARCHAR2(200) NOT NULL,  
        JOB_NAME  VARCHAR2(200) NOT NULL,   
        JOB_GROUP VARCHAR2(200) NOT NULL,  
        DESCRIPTION VARCHAR2(250) NULL,  
        NEXT_FIRE_TIME NUMBER(13) NULL,  
        PREV_FIRE_TIME NUMBER(13) NULL,  
        PRIORITY NUMBER(13) NULL,  
        TRIGGER_STATE VARCHAR2(16) NOT NULL,  
        TRIGGER_TYPE VARCHAR2(8) NOT NULL,  
        START_TIME NUMBER(13) NOT NULL,  
        END_TIME NUMBER(13) NULL,  
        CALENDAR_NAME VARCHAR2(200) NULL,  
        MISFIRE_INSTR NUMBER(2) NULL,  
        JOB_DATA BLOB NULL,  
        CONSTRAINT QRTZ_TRIGGERS_PK PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),  
        CONSTRAINT QRTZ_TRIGGER_TO_JOBS_FK FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)   
          REFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP)   
    );  
    -- 存储简单的 Trigger,包括重复次数,间隔,以及已触的次数  
    CREATE TABLE qrtz_simple_triggers  
      (  
        SCHED_NAME VARCHAR2(120) NOT NULL,  
        TRIGGER_NAME VARCHAR2(200) NOT NULL,  
        TRIGGER_GROUP VARCHAR2(200) NOT NULL,  
        REPEAT_COUNT NUMBER(7) NOT NULL,  
        REPEAT_INTERVAL NUMBER(12) NOT NULL,  
        TIMES_TRIGGERED NUMBER(10) NOT NULL,  
        CONSTRAINT QRTZ_SIMPLE_TRIG_PK PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),  
        CONSTRAINT QRTZ_SIMPLE_TRIG_TO_TRIG_FK FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)   
        REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)  
    );  
    -- 存储 Cron Trigger,包括 Cron 表达式和时区信息  
    CREATE TABLE qrtz_cron_triggers  
      (  
        SCHED_NAME VARCHAR2(120) NOT NULL,  
        TRIGGER_NAME VARCHAR2(200) NOT NULL,  
        TRIGGER_GROUP VARCHAR2(200) NOT NULL,  
        CRON_EXPRESSION VARCHAR2(120) NOT NULL,  
        TIME_ZONE_ID VARCHAR2(80),  
        CONSTRAINT QRTZ_CRON_TRIG_PK PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),  
        CONSTRAINT QRTZ_CRON_TRIG_TO_TRIG_FK FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)   
          REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)  
    );  
    CREATE TABLE qrtz_simprop_triggers  
      (            
        SCHED_NAME VARCHAR2(120) NOT NULL,  
        TRIGGER_NAME VARCHAR2(200) NOT NULL,  
        TRIGGER_GROUP VARCHAR2(200) NOT NULL,  
        STR_PROP_1 VARCHAR2(512) NULL,  
        STR_PROP_2 VARCHAR2(512) NULL,  
        STR_PROP_3 VARCHAR2(512) NULL,  
        INT_PROP_1 NUMBER(10) NULL,  
        INT_PROP_2 NUMBER(10) NULL,  
        LONG_PROP_1 NUMBER(13) NULL,  
        LONG_PROP_2 NUMBER(13) NULL,  
        DEC_PROP_1 NUMERIC(13,4) NULL,  
        DEC_PROP_2 NUMERIC(13,4) NULL,  
        BOOL_PROP_1 VARCHAR2(1) NULL,  
        BOOL_PROP_2 VARCHAR2(1) NULL,  
        CONSTRAINT QRTZ_SIMPROP_TRIG_PK PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),  
        CONSTRAINT QRTZ_SIMPROP_TRIG_TO_TRIG_FK FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)   
          REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)  
    );  
    -- Trigger 作为 Blob 类型存储(用于 Quartz 用户用 JDBC 创建他们自己定制的 Trigger 类型,<span style="color:#800080;">JobStore</span> 并不知道如何存储实例的时候)  
    CREATE TABLE qrtz_blob_triggers  
      (  
        SCHED_NAME VARCHAR2(120) NOT NULL,  
        TRIGGER_NAME VARCHAR2(200) NOT NULL,  
        TRIGGER_GROUP VARCHAR2(200) NOT NULL,  
        BLOB_DATA BLOB NULL,  
        CONSTRAINT QRTZ_BLOB_TRIG_PK PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),  
        CONSTRAINT QRTZ_BLOB_TRIG_TO_TRIG_FK FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)   
            REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)  
    );  
    -- 以 Blob 类型存储 Quartz 的 Calendar 信息  
    CREATE TABLE qrtz_calendars  
      (  
        SCHED_NAME VARCHAR2(120) NOT NULL,  
        CALENDAR_NAME  VARCHAR2(200) NOT NULL,   
        CALENDAR BLOB NOT NULL,  
        CONSTRAINT QRTZ_CALENDARS_PK PRIMARY KEY (SCHED_NAME,CALENDAR_NAME)  
    );  
    -- 存储已暂停的 Trigger 组的信息   
    CREATE TABLE qrtz_paused_trigger_grps  
      (  
        SCHED_NAME VARCHAR2(120) NOT NULL,  
        TRIGGER_GROUP  VARCHAR2(200) NOT NULL,   
        CONSTRAINT QRTZ_PAUSED_TRIG_GRPS_PK PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP)  
    );  
    -- 存储与已触发的 Trigger 相关的状态信息,以及相联 Job 的执行信息  
    CREATE TABLE qrtz_fired_triggers   
      (  
        SCHED_NAME VARCHAR2(120) NOT NULL,  
        ENTRY_ID VARCHAR2(95) NOT NULL,  
        TRIGGER_NAME VARCHAR2(200) NOT NULL,  
        TRIGGER_GROUP VARCHAR2(200) NOT NULL,  
        INSTANCE_NAME VARCHAR2(200) NOT NULL,  
        FIRED_TIME NUMBER(13) NOT NULL,  
        PRIORITY NUMBER(13) NOT NULL,  
        STATE VARCHAR2(16) NOT NULL,  
        JOB_NAME VARCHAR2(200) NULL,  
        JOB_GROUP VARCHAR2(200) NULL,  
        IS_NONCONCURRENT VARCHAR2(1) NULL,  
        REQUESTS_RECOVERY VARCHAR2(1) NULL,  
        CONSTRAINT QRTZ_FIRED_TRIGGER_PK PRIMARY KEY (SCHED_NAME,ENTRY_ID)  
    );  
    -- 存储少量的有关 Scheduler 的状态信息,和别的 Scheduler 实例(假如是用于一个集群中)  
    CREATE TABLE qrtz_scheduler_state   
      (  
        SCHED_NAME VARCHAR2(120) NOT NULL,  
        INSTANCE_NAME VARCHAR2(200) NOT NULL,  
        LAST_CHECKIN_TIME NUMBER(13) NOT NULL,  
        CHECKIN_INTERVAL NUMBER(13) NOT NULL,  
        CONSTRAINT QRTZ_SCHEDULER_STATE_PK PRIMARY KEY (SCHED_NAME,INSTANCE_NAME)  
    );  
    -- 存储程序的悲观锁的信息(假如使用了悲观锁)  
    CREATE TABLE qrtz_locks  
      (  
        SCHED_NAME VARCHAR2(120) NOT NULL,  
        LOCK_NAME  VARCHAR2(40) NOT NULL,   
        CONSTRAINT QRTZ_LOCKS_PK PRIMARY KEY (SCHED_NAME,LOCK_NAME)  
    );  

    create index idx_qrtz_j_req_recovery on qrtz_job_details(SCHED_NAME,REQUESTS_RECOVERY);  
    create index idx_qrtz_j_grp on qrtz_job_details(SCHED_NAME,JOB_GROUP);  

    create index idx_qrtz_t_j on qrtz_triggers(SCHED_NAME,JOB_NAME,JOB_GROUP);  
    create index idx_qrtz_t_jg on qrtz_triggers(SCHED_NAME,JOB_GROUP);  
    create index idx_qrtz_t_c on qrtz_triggers(SCHED_NAME,CALENDAR_NAME);  
    create index idx_qrtz_t_g on qrtz_triggers(SCHED_NAME,TRIGGER_GROUP);  
    create index idx_qrtz_t_state on qrtz_triggers(SCHED_NAME,TRIGGER_STATE);  
    create index idx_qrtz_t_n_state on qrtz_triggers(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE);  
    create index idx_qrtz_t_n_g_state on qrtz_triggers(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE);  
    create index idx_qrtz_t_next_fire_time on qrtz_triggers(SCHED_NAME,NEXT_FIRE_TIME);  
    create index idx_qrtz_t_nft_st on qrtz_triggers(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME);  
    create index idx_qrtz_t_nft_misfire on qrtz_triggers(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME);  
    create index idx_qrtz_t_nft_st_misfire on qrtz_triggers(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE);  
    create index idx_qrtz_t_nft_st_misfire_grp on qrtz_triggers(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE);  

    create index idx_qrtz_ft_trig_inst_name on qrtz_fired_triggers(SCHED_NAME,INSTANCE_NAME);  
    create index idx_qrtz_ft_inst_job_req_rcvry on qrtz_fired_triggers(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY);  
    create index idx_qrtz_ft_j_g on qrtz_fired_triggers(SCHED_NAME,JOB_NAME,JOB_GROUP);  
    create index idx_qrtz_ft_jg on qrtz_fired_triggers(SCHED_NAME,JOB_GROUP);  
    create index idx_qrtz_ft_t_g on qrtz_fired_triggers(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP);  
    create index idx_qrtz_ft_tg on qrtz_fired_triggers(SCHED_NAME,TRIGGER_GROUP);  

2、创建SimpleTrigger任务

SimpleTrigger任务

创建SimpleTrigger任务不用指定Cron表达式,可根据重复类型填写相应的重复次数与重复间隔(可以任务重复次数repeatCount与重复间隔repeatInterval是为重复类型指定参数)。

3、创建CronTrigger任务

CronTrigger任务

CronTrigger任务则是通过Cron表达式创建的任务,只需要在界面配置必填选项和Cron表达式即可。

4、修改任务

点击修改任务后,可进入到任务编辑界面,修改任务相关参数(任务名和任务组不可修改)。系统会通过rescheduleJob方法重新调度。

     // trigger已经存在,更新相应的定时设置
     TriggerBuilder triggerBuilder = trigger.getTriggerBuilder();
     trigger = setTriggerParam(job, triggerKey, triggerBuilder, trigger);
     // 按新的trigger重新设置job执行
     scheduler.rescheduleJob(triggerKey, trigger);

5、暂停任务

点击暂停任务,任务将挂起,任务状态由”NORMAL”变为“PAUSE”

      /**
     * 暂停
     */
    public void pauseJob(ScheduleJob scheduleJob) throws SchedulerException {
        Scheduler scheduler = schedulerFactoryBean.getScheduler();
        JobKey jobKey = JobKey.jobKey(scheduleJob.getJobName(), scheduleJob.getJobGroup());
        scheduler.pauseJob(jobKey);
    }

6、恢复任务

点击回复任务,任务将变为可执行状态,任务状态由”PAUSE”变为“NORMAL”

  /**
     * 恢复运行
     */
    public void resumeJob(ScheduleJob scheduleJob) throws SchedulerException {
        Scheduler scheduler = schedulerFactoryBean.getScheduler();
        JobKey jobKey = JobKey.jobKey(scheduleJob.getJobName(), scheduleJob.getJobGroup());
        scheduler.resumeJob(jobKey);
    }

7、删除任务

从数据库中删除任务

   /**
     * 删除
     */
    public void deleteJob(ScheduleJob scheduleJob) throws SchedulerException {
        Scheduler scheduler = schedulerFactoryBean.getScheduler();
        JobKey jobKey = JobKey.jobKey(scheduleJob.getJobName(), scheduleJob.getJobGroup());
        scheduler.deleteJob(jobKey);
    }

8、立即运行一次

点击“立即运行一次”,任务则马上执行一次

 /**
     * 运行一次
     */
    public void triggerJob(ScheduleJob scheduleJob) throws SchedulerException {
        Scheduler scheduler = schedulerFactoryBean.getScheduler();
        JobKey jobKey = JobKey.jobKey(scheduleJob.getJobName(), scheduleJob.getJobGroup());
        scheduler.triggerJob(jobKey);
    }
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值