Re: submit jobs

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Thu, 18 Nov 1999 11:22:47 -0800
Message-ID: <811jn9$379$1@plo.sierra.com>

dbms_job.submit() queues your job up for the NEXT_DATE and NEXT_SEC (DESCRIBE USER_JOBS) dbms_job.run(jobno) starts this job running right now.

Unless you have the INIT*.ora parameters

JOB_QUEUE_PROCESSES = < something other than 0, which is the defaul> and
JOB_QUEUE_INTERVAL = <number of seconds between wake ups, default = 60, mine is set for 3000>

your job will not automatically run on NEXT_DATE, NEXT_SEC.

see also page 7-3 of the Oracle 8 Server Administrator's Guide.

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 - 13:22:47 CST