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

Thread: Oracle DBMS Jobs

  1. #1
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995

    Oracle DBMS Jobs

    Hey Guys/Gals,
    I have an interesting question and one where I'm not in the position to be able actively test so hence the reason for the post.

    Say I have an Oracle job that is scheduled to run every hour and it just so happens that underlying circumstances make that job run longer than an hour.
    Since the job is still running, when it's time for the job to run again will Oracle spawn another process so that the same job is running twice or is Oracle smart enough to know that the job is still running and wait for the job to finish to launch it again?

    Also, any docs out there to vaidate what Oracle would actually do?

    Thanks for the help!
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    the next_time isnt set until the job finshes - so no you wont get 2 jobs, when the job finishes it will add the interval to that

    so if you have a job which runs every hour, it runs at 2pm but takes 90 mins, the next run i believe will be 4

  3. #3
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Cool,
    Thanks Dave!
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

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