MySql

Intégrés

L’ordonnanceur est intégré dans le progiciel et ne peut être utilisé qu’à travers lui.

Accès rapide

Config schedule EVENT (1 reply)

Can I schedule an event that runs between two hours and continue the next day? Start: 06.00.00 End: 07.00.00 interval: 15minutes

25 février 2018
source : MySQL Forums - Events (Job Scheduler)

status create event (1 reply)

When I create an event, the status is DISABLE. What am I doing wrong? my code: CREATE EVENT test ON SCHEDULE EVERY 1 MINUTE STARTS '2007-11-28 07:00:00' ENDS '2007-11-28 08:00:00' ON COMPLETION PRESERVE DO (...)

24 février 2018
source : MySQL Forums - Events (Job Scheduler)

Create an event on a table (1 reply)

Hi everyone, I'm working on an appointment scheduling system. I have an appointment table that contains appointment details, date-time and status. And I want to create an event that update the status of each appointment when its time passes. (...)

25 mai 2017
source : MySQL Forums - Events (Job Scheduler)

PREPARE STM1 syntax error (4 replies)

Hello, I want to execute the following script: SELECT @query := concat("SELECT * FROM test.station07 INTO OUTFILE 'c:/logs/test/", DATE_FORMAT(now(), '%Y_%M_%D'),".csv' FIELDS TERMINATED BY ',' (...)

14 avril 2017
source : MySQL Forums - Events (Job Scheduler)

Few Events don't run though they are enabled. (no replies)

Hi, I've around 45 Schemas in my MySQL Server instance and each schema have an event which runs every 7 minutes. I've noticed lately that few events don't run though they are enabled. There is every time a count of 2 events (...)

19 février 2017
source : MySQL Forums - Events (Job Scheduler)

A voir sur le net