MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: MySQL Events: How to schedule commands for every 1st day of the month?
Posted by: Peter Brawley
Date: November 12, 2019 01:23PM

I haven't tested it but you may be able to do it with MySQL events ...

CREATE EVENT ev_radacct_cpmonth
EVERY MONTH
STARTS '2011-05-01 00:00:00'
DO BEGIN ...

To check that it works, change the interval to hours or minutes/

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL Events: How to schedule commands for every 1st day of the month?
Cesar Murilo Cesar
November 12, 2019 07:44AM
Re: MySQL Events: How to schedule commands for every 1st day of the month?
Peter Brawley
November 12, 2019 11:47AM
Re: MySQL Events: How to schedule commands for every 1st day of the month?
Cesar Murilo Cesar
November 12, 2019 12:43PM
Re: MySQL Events: How to schedule commands for every 1st day of the month?
Peter Brawley
November 12, 2019 01:23PM


Sorry, you can't reply to this topic. It has been closed.

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.