Venkat,
You have two options:
use the linux cron utilityuse the (PL/SQL) supplied package:- DBMS_JOB Since both options require a lot of explanation, I don't think
a reply in this forum is a good way for you to learn how to
implement the two options. And since there is already a lot of
literature available that explains how to use the above two
options, allow me to refer you to some of that literature.
For using the "cron" utility, perhaps read the "crontab" man page
on your linux computer.
For DBMS_JOB, look up the Oracle documentation at the
Tahiti Web site.
Good Luck,
Avi.