Re: How work the job Queues DBMS

From: Steve Johnson <robertoc_at_fyiowa.infi.net>
Date: 1997/12/26
Message-ID: <34A3DD30.3E5D@fyiowa.infi.net>#1/1

If you make pass the next_date as null (sysdate) will be used and the job will execute immediately. Make sure you have a commit after you make a call to DBMS_JOB.SUBMIT.

Hope this works for you.

Steve J.

Laurent LETANG wrote:
>
> I want start a procedure immediatly.
> How doing it ?
> I use DBMS_JOB.submit(...)
> Nothing is working !
>
> Thanks for your help.
> --
> Laurent LETANG mailto:Laurent.Letang_at_ansf.alcatel.fr
> ALCATEL TITN ANSWARE
> 1, Rue du chateau de l'eraudiere
> 44300 NANTES FRANCE
Received on Fri Dec 26 1997 - 00:00:00 CST

Re: How work the job Queues DBMS_JOB