DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Scheduling

  1. #1
    Join Date
    Jun 2001
    Posts
    76
    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.

  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    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

  3. #3
    Join Date
    Jun 2001
    Posts
    76
    Sorry, but could you provide an example?

    Thanks,

    R
    On the other hand, you have different fingers.

  4. #4
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    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
  •  


Click Here to Expand Forum to Full Width