Re: JOB running once

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Thu, 13 Jun 2002 20:11:28 GMT
Message-ID: <3d08fbd2.702512299@news.globix.com>

set job_queue_interval=1
this doesn't guarantee right away, but within a minute use dbms_job.submit (v_job_num, 'your_proc;', sysdate) commit
/
check dba_jobs_running.

On 13 Jun 2002 12:23:01 -0700, tana_at_acedsl.com (Tana) wrote:

>HI,
>
>I need to submit a job and run it only once, right away.
>
>When user submits a request from front end, I want user not to wait
>until SP is completed. So, the idea is to run ORACLE job just once,
>and it needs to happen right away in a background.
>
>any help would be appreciated
>Tana

.......
We use Oracle 8.1.7.3 on Solaris 2.7 boxes remove NSPAM to email Received on Thu Jun 13 2002 - 15:11:28 CDT