dbms_job.submit and isubmit

[Scunningham99]

Hi

Anyone know the difference between dbms_job.submit AND dbms_job.isubmit
Thanks in Advance!!!

Sy UK

 

[SantaMufasa]

Sy,

A "side-by-side" comparison appears at

http://www.unix.org.ua/orelly/oracle/bipack/ch13_02.htm.

The differences appear to be at the "nuance" level. It would be helpful if the author came right out and said, "This is when you should use "DBMS_JOB.SUBMIT" and this is when you should use "DBMS_JOB.ISUBMIT", but they didn't. And besides the nuances, I don't know the answer, myself...Sorry.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[Scunningham99]

Hey thanks for info... I know its not exactly clear .. but hey thats Oracle for u cant make it tooo easy else everyone would be doing it!!



Sy UK

 

[lewisp]

The only difference I can tell is that you supply your own job number to isubmit. This allows you to know in advance of the job running what the number will be.

You have to ensure your job number is unique, so you may want to set up your own job number sequence.