dbms_job question

[zulu99]

Hi All

I have a doubt on dbms_job. Say i have a job which runs every 30 seconds . The whole job on certain condition may take more than 30 seconds to complete .

In this sceanrio will 2nd job process immediately start after the time lag of 30 seconds
is over or will it wait for the 1st job to complete.

Say if my 1st job take 1 min to finish & the job process runs every 30 seconds.

what will be the outcome

Regrds
Sushant

[gandolf989]

DBMS_JOB will sumbit a new job when the current job is finished. You should be able to setup a job that will run, and then wait 30 seconds to run again. However, since you don't know how long the job takes to run you can't predict when the job will be running. You can run multiple versions of the same job in a queue depending on your business needs. I think it might come done to a little experimentation on you part as to how you need to submit the job.

Be aware that becase the job gets resubmitted after it finishes that the start time may drift. Which is a topic that has been convered in this forum before.