Re: oracle job

Solaris77 <giofai_at_inwind.it> schreef in berichtnieuws bgr054$r953n$1_at_ID-203060.news.uni-berlin.de...
| Hi,
| i have 1 oracle job starting every 2 hours.
| My question is:
|
| if the oracle job starts 12:00 and it's running at 14:00 what's happening?
|
| The new job start or wait the finish of the first job??
|
| PS Sorry for my english!!
|
| Thank
| Giovanni
|

Oracle calculates the next job execution time when the job finishes. It uses the function you specified as the "interval" parameter. Example: - suppose interval is "sysdate +2/24" (means: every 2 hours) - job started to run at 12:00 (while running you can see that in dba_jobs columns this_date and this_sec or the view dba_jobs_running) - job finishes at 15:05 (see view dba_jobs columns last_date and last_sec) - Oracle calculates a new scheduled time (dba_jobs columns next_date and next_sec) using interval, resulting in 17:05 in this example. Received on Wed Aug 06 2003 - 13:00:53 CDT