Scheduled Database Updates on Given Date - MySQL & PHP

Question

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.

Ask for Access OR manually run the script each month

Shakti Singh
– Shakti Singh

2012-06-05 05:48:27 +00:00
Commented Jun 5, 2012 at 5:48 — Shakti Singh
– Shakti Singh, Commented Jun 5, 2012 at 5:48

Ruben Nagoga · Accepted Answer · 2012-06-05 06:23:56Z

1

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.

answered Jun 5, 2012 at 6:23

Ruben Nagoga

2,2182 gold badges20 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Praveen Kumar Over a year ago

I was thinking of this, Coz I'm working on OSTicket, It uses the same thing. Thanks :)

Kat Cox · Accepted Answer · 2015-03-29 03:16:46Z

0

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).

edited Mar 29, 2015 at 3:16

Kat Cox

3,5712 gold badges21 silver badges30 bronze badges

answered Jun 5, 2012 at 6:24

Joe

2,6136 gold badges40 silver badges61 bronze badges

Collectives™ on Stack Overflow

Scheduled Database Updates on Given Date - MySQL & PHP

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related