Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> submit jobs
i want to run a procedure as a job in the background
i tried this:
DBMS_JOB.SUBMIT(jobno,proc_name,sysdate+1/(25*60));
nothing happens
then I tried this:
DBMS_JOB.SUBMIT(jobno,proc_name);
DBMS_JOB.RUN(jobno,true);
Now the procedure proc_name is running, but I have to wait until its
finished.
Who can help me?
Andi Schwaiger
Austria
Received on Thu Nov 18 1999 - 06:30:06 CST