Cron Commands - mymagic/open_hub GitHub Wiki

OpenHub rely on cron to run scheduled tasks automatically, examples:

Update currency conversation data automatically on daily basis
Process user request to download their personal data

How to add command to cron

This is the recommended method to add command to cron, using a bash file and lock the process id to prevent multiple instance being call caused duplicated job running concurrently.

create /_cron/ directory
Make sure there is a writable empty folder in /_cron/runtime.
Create a bash file to create junk record in database for testing: /_cron/bash/test-createJunk.sh

#!/bin/bash
# lock dirs/files
LOCKDIR="${1}/runtime"
PIDFILE="${LOCKDIR}/test-createJunk.pid"

if [ -f $PIDFILE ]
then
    PID=$(cat $PIDFILE)
    ps -p $PID > /dev/null 2>&1
    if [ $? -eq 0 ]
    then
        echo "Process already running"
        exit 1
    else
        ## Process not found assume not running
        echo $$ > $PIDFILE
        if [ $? -ne 0 ]
        then
            echo "Could not create PID file"
            exit 1
        fi
    fi
else
    echo $$ > $PIDFILE
    if [ $? -ne 0 ]
    then
        echo "Could not create PID file"
        exit 1
    fi
fi

echo "start";
myYear=`date +'%Y'`
myMonth=`date +'%m'`
php $LOCKDIR/../../protected/yiic test createJunk --note="Hello.. Year:${myYear} Month: ${myMonth}"
sleep 20s #simulate a long running process
echo "end";

rm $PIDFILE

Make sure this bash file is executable, try it with command:

/var/www/_cron/bash/test-createJunk.sh  /var/www/_cron

0 * * * * /var/www/_cron/bash/test-createJunk.sh /var/www/_cron

Now, you should be able to find new database record added to junk table every hour automatically. Remember to disable this after tested.

Sample of basic cron setting

0 */4 * * * /var/www/_cron/bash/updateCurrencyExchangeRate.sh /var/www/_cron
0 * * * * /var/www/_cron/bash/processUserDataDownloadRequest.sh /var/www/_cron

# only for production, email out
0 1 * * * /var/www/_cron/bash/f7-emailSurveyAfterEvent1Day.sh /var/www/_cron
0 1 * * * /var/www/_cron/bash/f7-emailSurveyAfterEvent6Month.sh /var/www/_cron