MySQL Forums
Forum List  »  Events (Job Scheduler)

Need solution for Event not working
Posted by: Nataraja mani
Date: March 20, 2019 06:44AM

Dear team,

I need solution for MySQL Event Not working.

I need to run 3 MySQL Events of followings.

1. Every 1 day once at 12.00 AM.

2. Every 1 month once at 12.00 AM.

3. Every 1 year once at 12.00 AM.

When I run the Mysql Event , if Current date and time is 11:50 PM .

the event should not fired at 11:50 PM on first , It should be fired only on next day 12.00 PM.

Here I am checking Mysql Events in My PC . It does not work properly.

if I change the time , Is MySQL event get closed ? or NOT ?

Kindly provide the Event queries for the above mentioned 3 events.

Options: ReplyQuote


Subject
Views
Written By
Posted
Need solution for Event not working
130
March 20, 2019 06:44AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.