Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB sessions question
You could record the time in the job in a variable (v_start_time:=sysdate;)
and in a loop in your PL/SQL test the delta od the v_start_time and sysdate
and see if the delta is larger than the amount of time you want it to run.
If so have it exit gracefully.
Jim
<salman_z_g_at_hotmail.com> wrote in message
news:8o6nl2$jt3$1_at_nnrp1.deja.com...
> Do all job invocations share the same session?
>
> If Yes,
> What to do if I want to restrict session time of a single job
> invocation?
>
> I saw the trc file for the job failures and they show same session id
> (23) and the error about the session limit.
>
> It shows session id like 23.2342
> Seems like 23 is the session id - whats the part after the period that
> different for every call?
>
> Please reply asap.
>
> Thanks.
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Aug 27 2000 - 17:19:09 CDT