Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Run a job every 30min but only from 6am to 6pm

463258Jun 14 2006 — edited Sep 7 2007

I have a job that runs every 30 mins to process orders, and email failures. I only want this job to run from 6or 7am to 6pm M-F. I have other jobs that run once a day starting 1 minute past midnight. and and 4am. I do not want any conflicts as the both read the same tables. Using Enterprise Manager in 10g, I can only see how to schedule a job to repeat and start and stop but I want it to resbmit the schedule.

Is this possible or will I have to schedule a 25 jobs to run ever 24hrs?

thanks

bj

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 5 2007

Added on Jun 14 2006

#database-key-features, #scheduler

6 comments

4,359 views