修改quartz定时任务已注册的trigger cron表达式

修改代码cronExpression配置,如果任务已经注册不再更新配置,需要手动执行数据库语句

1.更改表qrtz_cron_triggers的cronExpression(定时任务时间)

例子:

UPDATE QRTZ_CRON_TRIGGERS SET CRON_EXPRESSION = '0 0 0/1 ?' WHERE SCHED_NAME = 'Cluster_iflydocs_fs_dev' AND TRIGGER_NAME = 'RecycleBinTrigger' AND TRIGGER_GROUP = 'trigger_iflydocs_fs_dev';

2.将表qrtz_triggers的NEXT_FIRE_TIME(下一次执行时间)和PREV_FIRE_TIME(上一次执行时间)的值改为0

例子:
UPDATE QRTZ_TRIGGERS SET NEXT_FIRE_TIME = 1633770000000, PREV_FIRE_TIME = 1633766400000 WHERE SCHED_NAME = 'Cluster_iflydocs_fs_dev' AND TRIGGER_NAME = 'RecycleBinTrigger' AND TRIGGER_GROUP = 'trigger_iflydocs_fs_dev';

发表新评论