Run Jobs One After Another

[joero4]

I know this is possible, I'm not sure how to go about it using Oracle's Scheduler. I simply want to create a special "queue" that I can submit jobs to which will run one after another. After they run, then then are gone. There many be no jobs at anyone time, and then at other times I may submit 10 jobs to the queue. Currently when I submit jobs they all run parrallel, this is not what I want. I guess I don't understand why Oracle calls it a Job Queue when all my jobs run in parrallel and not in a queue as the name implies.

This is not say that I don't have other jobs which I would not want to send to this "queue". In other cases I would just want to submit the job and let it run right away and not wait on anything.

I'm currently using the DBMS_JOB package, which I'm pretty sure won't let me do what I want.

Any help would be greatly appreciated.

Thanks,
Joe

 

[LKBrwnDBA]

Check out 'JOB CHAINING' in the Oracle DB Administrator's Guide


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb