CODEWITHSUNDEEP
phpmysqlcronscheduled-tasks
Praveen Kumar
Praveen Kumar

Reputation: 89

Scheduled Database Updates on Given Date - MySQL & PHP

I have a requirement where I need to Update some fields in database on monthly basis, I know I can use Cron Jobs, But I don't have access to use Cron, So is there any other way doing this in PHP, MySQL, JQuery or any other ??

I just need to update & Insert some rows in Database Tables on the scheduled time Automatically.

Upvotes: 0

Views: 518

Answers (2)

Joe
Joe

Reputation: 2591

Have you ever heard of MySQL Event Scheduler?

Info

Creating event

Do you have access to it? If you want to check whether event_scheduler is running you can type show processlist - there should be a process run by User 'event_scheduler'. If not you can always run it.

Of course the best way is to add event_scheduler = ON in mysql config file (in mysqld section).

Upvotes: 0

Ruben Nagoga
Ruben Nagoga

Reputation: 2218

If you have site or something else with regular visits you can check with each visit is it time to run you job or not. If I not mistake wordpress's jobs are working in this way.

Upvotes: 1

Related Questions