eas后台事务表定时任务表

2019独角兽企业重金招聘Python工程师标准>>>

t_job_def 定时任务定义 t_job_trigger 定时任务的触发 t_job_inst 定时任务运行记录(近期) t_job_insthst 定时任务运行良录(中期)

相关查看后台事务运行中的sql如下，根据所需状态，修改fstate的条件或者不要这个条件

SELECT t.ftitle,
       t1.fscheduleplan,
       t1.flasttriggeredtime,
       (SELECT MAX(c.fcreatedtime)
          FROM t_job_inst c
         WHERE c.fjobdefid = t.fjobdefid
               AND (c.fstate = 'Complete' OR c.fstate = 'Running')
         GROUP BY c.fjobdefid) AS flastruntime,
       (SELECT MAX(c.fcreatedtime)
          FROM t_job_insthst c
         WHERE c.fjobdefid = t.fjobdefid
               AND (c.fstate = 'Complete')
         GROUP BY c.fjobdefid) AS flastruntime2
  FROM t_job_def t
 INNER JOIN t_job_trigger t1 ON t1.fjobdefid = t.fjobdefid
 WHERE t1.fisvalid = 'Y'
 ORDER BY t1.flasttriggeredtime DESC;

这个用来查出启用中的定时任务,和它们的运行信息(只查看 运行中,已完成 的任务,其它状态视为运行失败).

转载于:https://my.oschina.net/moshowgame/blog/1789845