Apache Dolphinscheduler
停止任务
update t_ds_task_instance set state = 6 where state != 7 update t_ds_process_instance set state = 6 where state != 7
Warning
yyyy-MM-dd HH:mm:ss 必须改为将来时间
UPDATE QRTZ_TRIGGERS
SET NEXT_FIRE_TIME = (EXTRACT(EPOCH FROM TIMESTAMP 'yyyy-MM-dd HH:mm:ss') * 1000)::BIGINT;
- mysql SELECT job_name, FROM_UNIXTIME(NEXT_FIRE_TIME / 1000, '%Y-%m-%d %H:%i:%s') AS next_fire_time_fmt FROM QRTZ_TRIGGERS;
通过将NEXT_FIRE_TIME 改为当前时间来停止历史任物
查看是否有调度
select * FROM dolphinscheduler.QRTZ_CRON_TRIGGERS;
job_name 是 t_ds_schedules 表的id 加 job_
update QRTZ_TRIGGERS set NEXT_FIRE_TIME = UNIX_TIMESTAMP('2025-11-08 10:30:00') * 1000
- pgsql SELECT job_name, TO_TIMESTAMP(NEXT_FIRE_TIME / 1000) AS next_fire_time_fmt FROM QRTZ_TRIGGERS;
UPDATE QRTZ_TRIGGERS SET NEXT_FIRE_TIME = (EXTRACT(EPOCH FROM TIMESTAMP '2025-11-08 10:30:00') * 1000)::BIGINT;
update t_ds_task_instance set state = 6 where state != 7 update t_ds_process_instance set state = 6 where state != 7
t_ds_process_instance
state 流程实例状态：0 提交成功,1 正在运行,2 准备暂停,3 暂停,4 准备停止,5 停止,6 失败,7 成功,8 需要容错,9 kill,10 等待线程,11 等待依赖完成
t_ds_task_instance state 任务实例状态：0 提交成功,1 正在运行,2 准备暂停,3 暂停,4 准备停止,5 停止,6 失败,7 成功,8 需要容错,9 kill,10 等待线程,11 等待依赖完成
update set state = '9' t_ds_process_instance where state not in ('5','6','7')
变量
http
Note
日志中打印的变量并不会替换
${变量名}