How to set cron every one minute

[tbworld]

Originally Posted by CAG CheechDogg

Well, what is the cron job supposed to do? Are you using cPanel?

Good point @CheechDogg, I have direct access to my servers so I tend to forget about cPanel.

[CAG CheechDogg]

You can use the following to set up a cron job if you have cPanel, make sure you copy it and paste it then replace the red highlighted fields with your own, do not add or take away any spaces or it will not work.

Add it inside the Command box field

mysql -u prefix_user -pPassword -h localhost -D prefix_database -e"TRUNCATE TABLE prefix_table_name"

This cron job will delete (truncate) the table you name.

Here is how this works:

-u = your mysql username

-p = your username's password

-h = local host

-D = your database to perform the cron job on

-e = is the actual command to give table within the database

You will then leave * for every field starting with the minute all the way to the weekday to make the cron job work every min...

It will be up to you to find out what command it is you are trying to make this cron job do.

Hope this helps you out...

p.s. Make sure you copy and paste this exactly how I posted it here, any extra spaces where they don't belong will break the cron job ....

--------------- Added [DATE]1380419552[/DATE] at [TIME]1380419552[/TIME] ---------------

If you have customer support you can also have them help you write up your cron job, this is just one example of a type of cron job you can set ...

--------------- Added [DATE]1380419848[/DATE] at [TIME]1380419848[/TIME] ---------------

If you can give me the host you are using I can probably help you with this further, there are cron jobs for different things like :

Command to run a PHP5 cron job:
php /home/username/public_html/cron.php

Optional flags are sometimes required for a PHP cron job:
php -q /home/username/public_html/cron.php

The list goes on and on ....