Server Cron Job Sample

crontab

0 0 * * * /home/username/run_cron.sh

run_cron.sh

# Get date of today
_now=$(date +"%m_%d_%Y")

# Sample 1: backup MySQL database
_file="/home/username/backup/db_$_now.sql"
mysqldump -u root -p'password' db_name > "$_file"

# Sample 2: calling web request (e.g. invoke API)
_url="http://localhost/website/daily_cron"
_file="/home/username/log/cron_$now.txt"
wget "$_url" -O "$_file"