Mladen Gogala <gogala@(protected)> wrote: On 03/02/2006 08:25:07 AM, Peter Alteheld wrote:
> Does Oracle on its own do something like a rescheduling that is cleaning up the context of a job? >
Sounds like a bug in Oracle 8i. Have you tried with Oracle 10.2?
No. Since in 10g DBMS_SCHEDULER was introduced, I guess DBMS_JOB hasn't changed much after 9.2. But we are still on 8i.
Peter
-- ---- ---- ---- ---- ---- ----- Telefonieren Sie ohne weitere Kosten mit Ihren Freunden von PC zu PC! Jetzt Yahoo! Messenger installieren! <BR><BR><B><I>Mladen Gogala <gogala@(protected)></I></B> wrote: <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT : #1010ff 2px solid"> <div><BR>On 03/02/2006 08:25:07 AM, Peter Alteheld wrote: <BR><BR>> Does Oracle on its own do something like a rescheduling that is cleaning up the context of a job?<BR>> <BR><BR>Sounds like a bug in Oracle 8i. Have you tried with Oracle 10.2?<BR><BR></div> <div>No. Since in 10g DBMS _SCHEDULER was introduced, I guess DBMS_JOB hasn't changed much after 9.2. But we are still on 8i. <BR></div> <div>Peter</div></BLOCKQUOTE><p> <hr size=1>Telefonieren Sie ohne weitere Kosten mit Ihren Freunden von PC zu PC!<br>Jetzt <a href=http://de.messenger.yahoo.com>Yahoo! Messenger</a> installieren!