Uderc programming article aggregator sites

Job with multiple event schedules

Tags:
Answers: Have 4 answers
Advertisement
Is it possible to create a job with multiple schedules? Can you have multiple schedule names?
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'my_new_job2',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN SALES_PKG.UPDATE_SALES_SUMMARY; END;',
schedule_name => 'my_saved_schedule, my_saved_schedule2'); <------------------ like this?
END;
thanks.
Advertisement
The best answer: I am using oracle 10g and have installed the file arrival package. I want my job to run when multiple files arrive. I have created the file arrival event schedules. I know i can create chain event steps to respond, but my chain has to be running for the steps to respond to the events. I want the chain (or rather the job that starts the chain) to kick off when 2 or more files arrive.
thanks.