通过执行:

  SELECT * FROM information_schema.EVENTS;

查看当前选定的数据库在执行了哪些事件。

可以看到相应的库中的作业信息,其中LAST_EXECUTED字段会反映出相应的作业最近一次的执行时间。

 

也可以通过:

select * from mysql.event\G

查看

root@localhost:mysql-3306.sock  11:22:  [s2b]>select * from mysql.event\G
*************************** 1. row ***************************
                  db: sss
                name: event_wxm_setTimeoutFlagForSyncSapJob
                body: UPDATE `trade_tertiary_order` SET sap_timeout = 1 where sap_timeout = 0 AND id in  = 1) a)
             definer: dddd@%
          execute_at: NULL
      interval_value: 20
      interval_field: MINUTE
             created: 2019-12-17 16:57:41
            modified: 2019-12-17 16:57:41
       last_executed: 2020-03-02 03:17:41
              starts: 2019-12-17 08:57:41
                ends: NULL
              status: ENABLED
       on_completion: DROP
            sql_mode: STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUT
             comment: 处理超时订单标记
          originator: 101
           time_zone: SYSTEM
character_set_client: utf8mb4
collation_connection: utf8mb4_general_ci
        db_collation: utf8mb4_unicode_ci
           body_utf8: UPDATE `trade_tertiary_order` SET sap_timeout = 1 where sap_timeout = 0 AND id in  = 1) a)
1 row in set (0.00 sec)