...

Firing off SQL via Cron

fritz Jung
07-24-2002, 03:11 PM
A newbie here...

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...

Spookster
07-24-2002, 03:38 PM
You can write an sql script then run it using crontab:

http://www.dbaoncall.net/references/ht_use_crontab.html



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum