i got one requirement like i have to schedule one procedure which is running in other than peak hours.
can any body help me how to automate the job in Oracle10g.
actually i studied about dbms_scheduler but it is not understood by me.
assume i have the table like
crate table t1(id number,name varchar2(10))
insert into t1 values(101,'testjob')
now give me one example like every day 12AM i have to run my insert script i.e how can i automate it.