get Mysql Event status

Question

I can get event in mysql by

SHOW EVENTS LIKE 'e29'

but it is giving all information. it is like

select * from ....

My need is that i want to get the STATUS of a particular event

score 1 · Accepted Answer · edited Apr 25 '14 at 11:09

1

Show events is not a regular statement that returns a cursor to read on.

You have to query information_schema.events to know status of an event.

mysql> select event_name, status -- from events where event_name =
    -> from information_schema.events where event_name = 'event_scheduling_sample';
+-------------------------+---------+
| event_name              | status  |
+-------------------------+---------+
| event_scheduling_sample | ENABLED |
+-------------------------+---------+
1 row in set (0.01 sec)

edited Apr 25 '14 at 11:09

Govind Singh

15,282
14
72
106

answered Apr 25 '14 at 10:53

Ravinder Reddy

23,692
6
52
82

thanks, i even don't know about the `information_schema`, after this i will surely read about it. – Govind Singh Apr 25 '14 at 11:20
1

Documentaion on [*`Information_Schema`*](https://dev.mysql.com/doc/refman/5.6/en/information-schema.html#idm47566336848448) – Ravinder Reddy Apr 25 '14 at 11:29

score 0 · Answer 2 · edited Dec 02 '15 at 13:33

0

You can also use

select @@event_scheduler;

to show the status.

edited Dec 02 '15 at 13:33

Marco Bonelli

63,369
21
118
128

answered Dec 02 '15 at 12:59

Reign.85

2,420
1
28
28

get Mysql Event status

2 Answers2