asked on

Cron Job that runs php script every hour

Hi,

I need help setting up a cron job on a server. The purpose of the cron job is to run a php script every hour. The script deletes the contents of some tables in a mySQL database.

I have tried to use the following (from this tutorial):

curl -s -o /dev/null http://www.domain.com/cleanup.php?clean=log

Even though the script runs nicely if I run it from a browser manually, the cron job doesn't run the script.

I have another cron job that works:

php -f /var/www/domain.com/public_html/shell/indexer.php -- reindexall >/dev/null 2>&1

I don't have access to the cPanel, so I have to tell my web hosting company to set up the job on the server.

Thanks!

Dio

omarfarid

Look into the following when running a crontab job:

1- set the env. variables for the script to run
2- use full pathnames to files and dirrctories
3- redirect output and errors to files that you can check later.
4- specify the shell to use to run the script with.

Do you get any errors while running the crontab job?

webdesigner_dk

ASKER

Thanks for the answer. I get this in the log:

Sep 11 18:05:01 prod9 /USR/SBIN/CRON[18161]: (root) CMD (curl -s -o /dev/null http://www.domain.com/cleanup.php?clean=log)

Any ideas?

omarfarid

I think this means the job was run at that time

but did you try to put the command in a shell script with setting env. variables etc?

ASKER CERTIFIED SOLUTION

webdesigner_dk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

webdesigner_dk

ASKER

My web hosting company managed to solve the problem. They didn't give any details though.