Can anyone point me to the basics of how firing off a sql statement can be done automatically by CRON on a unix box?
Essentially I want to have a sql sript that clears daily totals in a table every night at 00:01 am -- I understand the script part... but I don't know HOW that happens with Cron
Thanks...
You can write an sql script then run it using crontab: