Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    3

    Unanswered: Oracle Jobs question

    Do oracle_jobs need to be re-run if the machine cotnaining the DB is shut down or restarted?

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    JOBS are stored in tables

    Hello,

    the Oracle jobs are stored in tables ... so if a database will bes shut down and start again, the jobs will start again at the next time interval.

    This will be done by Oracle

    Hope that helps ?

    Regards
    Manfred Peter
    (Alligator Company GmbH)
    http://www.alligatorsql.com

  3. #3
    Join Date
    Sep 2002
    Location
    Austria
    Posts
    37

    Re: Oracle Jobs question

    Originally posted by pthompson2002
    Do oracle_jobs need to be re-run if the machine cotnaining the DB is shut down or restarted?
    to be a bit mor precise: if a job is running while the db is shutting down (using immediate or abort), this job will be killed/cancelled/rollbacked - this job will be restarted as soon as the db is up and running again.

    if your job should be running at a specific time and the db is down during at that specific time, this job will also be started as soon as the db is up and running.
    You might/should thus consider, that an interval like 'sysdate+1', which means that your job should run once a day does not imply, that the job will be rerun at the same time (each day).

    rgds

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •