What if a job in DBMS_JOB executes more than the INTERVAL?

According to the Oracle docs:

"The INTERVAL date function is evaluated immediately before a job is executed. If the job completes successfully, the date calculated from INTERVAL becomes the new NEXT_DATE. If the INTERVAL date function evaluates to NULL and the job completes successfully, the job is deleted from the queue. "

So INTERVAL is calculated BEFORE the job is executed, and INTERVAL becomes NEXT_DATE after the job is completed. If my understanding is correct, this mean that if the job, for whatever reason, took more time such that it actually was still running at the time of the next interval, and then finished running .... the job will never run again .... because by the time the job finished, NEXT_DATE will be INTERVAL which has already passed.

Am I right?

John Received on Wed Feb 06 2002 - 00:20:57 CST