Comments - Events Overview

7 years, 7 months ago Kai Börner

A few months ago I created an event by:

create event create_rechnung
on schedule every 1 month starts timestamp('2017-03-01 00:00:00')
on completion preserve
do insert into rechnung set rechnung_monat = now();

The included Insert-Statement works fine standalone. But the event was never executed. "show events" shows this:

Name                |Value
--------------------|-------------------
Db                  |tv2bw
Name                |create_rechnung
Definer             |tv2bw@localhost
Time zone           |SYSTEM
Type                |RECURRING
Execute at          |
Interval value      |1
Interval field      |MONTH
Starts              |2017-03-01 00:00:00
Ends                |
Status              |ENABLED
Originator          |0
character_set_client|utf8
collation_connection|utf8_general_ci
Database Collation  |utf8_general_ci

What did I do wrong?

 
7 years, 7 months ago Ian Gilfillan

Is the event_scheduler off? See Executing events.

 
7 years, 7 months ago Kai Börner

THANKS! I just didn't read that line.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.