-
I have 6 jobs that I would like to run sequentually and need them to start immediately one after another. Each job takes between 30 and 200 minutes to complete each day, so I cannot have them run at set times. Is there any way to say something like:
dbms_jobs.submit->(:jobno,'sum_tab_pop',trunc(sysdate),"trunc(select last_day from user_jobs where job = 1)");
Thanks in advance,
R
On the other hand, you have different fingers.
-
Why don't you let the job schedule the next one ?
Then, you only have to schedule JOB1, the others will be scheduled from within the different jobs.
Regards
Gert
-
Sorry, but could you provide an example?
Thanks,
R
On the other hand, you have different fingers.
-
Another and very similar solution to the denevge's one could be to create a procedure(function) that calls these six jobs sequentially and schedule only this procedure.
Ales
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|