I have been tasked to investigate if we can move all our jobs from dbms and table based jobs that are scheduled using submit next jobs procedure into the Scheduler
there are several jobs that concern;
one runs every 3 seconds - this job can take 20 mins to complete, and there can be multiples running concurrently 8 - 9 at a time
so my question is it possible to use Scheduler to simply kick of the job and then 3 seconds kick it off again ?
or would the first run started 3 seconds ago need to finish before the next could fire ?
are there any solutions for this?
i thought maybe you could create a script that creates a new job entry every 3 seconds that is named differently so that they can run concurrently however i hope there is a simpler built in solution
DB - 11g
Thanks