Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB
A copy of this was sent to Carl Hothersall <carlhothersall_at_mcmail.com>
(if that email address didn't require changing)
On Thu, 21 May 1998 17:36:16 +0100, you wrote:
>Dear All,
>
>Please can anyone give me a bit of advice on getting DBMS_JOB working?
>
>I have a Form through which parameters are entered. When the user hits
>commit, the idea is that the form executes a stored package, passing it
>the parameters that have been entered. I want the package to execute in
>the background, so that the user can navigate to other parts of the
>on-line system. I thought DBMS_JOB would do this, but can't quite get
>it to work:
>
>Using DBMS_JOB.SUBMIT, absolutely nothing appears to happen.
>
>Using DBMS_JOB.SUBMIT, followed by DBMS_JOB.RUN, the procedure executes,
>but in the same process as the form, so the form is locked until the
>procedure finishes.
>
Are you commiting after the DBMS_JOB.SUBMIT call? If not, you have simply put a job in the queue that no other session can see yet (until you commit that is).
>I tried DBMS_JOB.SUBMIT from SQL*Plus, and unlike from the form, it did
>at least create an entry in USER_JOBS, but did nothing else.
>
>I have the following parameters set in INIT.ORA (and the instance has
>been restarted):
>
>JOB_QUEUE_PROCESSES = 1
>JOB_QUEUE_INTERVAL = 60
>
>Any help would be much appreciated - thanks in advance.
>
>Regards,
>
>Carl Hothersall. (carlhothersall_at_mcmail.com).
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu May 21 1998 - 11:57:29 CDT
![]() |
![]() |