Why don't you write a plsql procedure and use the dbms_job package to schedule it. That would be the one way.

The second is write a shell/batch sql script and schedule it using the crontab on unix and at on windows.

Sam