Re: submit jobs

Andreas Schwaiger schrieb:

>
> 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?

What values do you get executing this statement as user system?

select
 name ,
 value
from v$parameter
where upper(name) like '%JOB%';

We have set these parameters to

job_queue_processes                   | 1
job_queue_interval                    | 120
job_queue_keep_connections            | FALSE

Look into your Manual or ask you Ora-Admin...

Regards, Stephan

--
---------------------------------------------------------------
Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-0           | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------
       PGP-Key verfügbar       |      PGP-Key available
---------------------------------------------------------------