Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: submit jobs
try
ALTER SESSION DISABLE RESTRICTED SESSION
Roland Daane
Andreas Schwaiger <andreas.schwaiger_at_strasser.at> wrote in message
news:3833f258.0_at_news.kabsi.at...
> 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 - 12:19:11 CST