I want to schedule execution of a procedure on Oracle 8i ( 8.1.5 ) server,
so that it runs automatically. I have submitted that procedure using DBMS_JOB.SUBMIT
function & has defined to the interval to run as Every Hour ( SYSDATE + 1/24 ).
My problem is that procedure is not getting executed If i manually run that job
using JOBID it runs fine.
So what can be the problem ?
Is there Anybody who can help me out ?
Thanks in advance.