Results 1 to 2 of 2

Thread: Dba_jobs

  1. #1
    Join Date
    Dec 2003

    Unanswered: Dba_jobs


    if I setup some jobs in oracle, and I specifiy that is must run at 10 am and then every 4 hours, but database goes down for backup for example during 5 hours. Then the job runs immediate after database startup. I would like that the jobs run always at the same time (for example at 10am), but also 4 hours between it as long as the database is online. If my database restart after backup, the job won't runt at 10am. Is there some parameter I can change that it runs at static time?


  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    If you're using 10g you need to be looking at blackout windows & retry period enabling/disabling; this link will start you off:
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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