How to write and execute cron job command in php script?

Question

I'm trying to execute a cronjob command from the script for this I'm writing below code, but nothing is happening.Can someone please help me out here.

$query ="INSERT INTO master_schedule_email(date, time,active_status) VALUES ('$date','$time','1')";
$exec = mysql_query($query) or die ("Error in Query".mysql_error());

    $minute = date ('i' , strtotime($time)); 
    $hour = date ('H' , strtotime($time));
    $date = date ('d' , strtotime($date));
    $month = date ('m' , strtotime($date));

$croncommand = "$minute $hour $date $month * monthlyautomaticmail.php";
exec($croncommand);

Here, I want to run the cron job command at the exact time and date which is inserting to the db table.

May I know is this the correct way to schedule a cronjob from php script?

I thought this is how we execute a terminal command from php script but I'm getting nowhere.Please someone help me out here. Thank you.

Possible duplicate of replace crontab file with -e

Agnius Vasiliauskas
– Agnius Vasiliauskas

2019-01-10 09:03:46 +00:00
Commented Jan 10, 2019 at 9:03 — Agnius Vasiliauskas
– Agnius Vasiliauskas, Commented Jan 10, 2019 at 9:03

Fabian · Accepted Answer · 2019-01-10 08:20:43Z

1

Assuming you want to schedule new cronjobs, this is not the way to go about it.

I suggest creating a database table for scheduled jobs with a date field for when they should be executed and a date field for when they were last executed. Then you manually create a cronjob to run a script that checks the new table to see if there are any jobs that are past their due date (scheduled_datetime > current_datetime && last_execution_datetime < scheduled_datetime). If so, it runs them and updates the last_execution_datetime to the time and date of the execution.

answered Jan 10, 2019 at 8:20

Fabian

6911 gold badge6 silver badges13 bronze badges

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

2 Comments

Srikar Reddy Over a year ago

Actually my aim here is to schedule a cronjob dynamically right after an insert query with those time and date variables passing in to the command.

Fabian Over a year ago

Yes, if I understand your code correctly you want to schedule the sending of an outgoing email. Is it a one time sending or is the same mail going out regularly? In the first case it can be made simpler. Create a column in the email table to keep track of whether the email has been sent or not. Create a script that checks if the email is past its scheduled sending time and if it has been sent. If it is not yet sent and the time is passed, then have the script execute your monthlyautomaticemail.php. Create a cronjob to run the first script as often as you'd like to check, maybe once a minute.

Collectives™ on Stack Overflow

How to write and execute cron job command in php script?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related