Xref: alice comp.databases.oracle.tools:35931 Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!newsfeed.tli.de!news.b-1.de.contrib.net!stargate.beusen.de!nobody From: Stephan Born Newsgroups: comp.databases.oracle.tools Subject: Re: submit jobs Date: Fri, 19 Nov 1999 11:27:36 +0100 Organization: beusen unternehmensgruppe senkel Systeme GmbH Lines: 44 Message-ID: <38352618.288570AF@beusen.de> References: <3833f228.0@news.kabsi.at> Reply-To: stephan.born@beusen.de Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Mailer: Mozilla 4.5 [de] (WinNT; I) X-Accept-Language: de,en 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@beusen.de | Germany --------------------------------------------------------------- PGP-Key verfügbar | PGP-Key available ---------------------------------------------------------------