Dinamic scheduling

Did your procedures run independently or affect each other ?

If they run independently simply create a function that get procedure ID as parameter read run date from table and return it. Use this procedure to get next run date. If you use Scheduler then repeat_interval will be this function.

create or replace function get_next_date(p_procedure_id in number) return date as
v_retval date;
begin
select date into v_retval from <table> where procedure_id=p_procedure_id;
return v_retval;
end;
/

then define job with procedure ID 1

begin
dbms_scheduler.create_job(name=>'<job_name>',job_action=>'your_procedure',repeat_interval=>'get_next_date(1)',start_date=>..., enabled=>true);
end;
/

When you procedures affect each other then define job for each procedure in disabled state and don't set start_date.

Instead of write next run date into table simply set start_date for appropriate job and enable it.

Start required jobs by setting start_date and enabling them.

Hi,

There are several ways to do that. You can change the repeat_interval/start_date of your job according to your custom table settings. You don't necessarily need a table, you can change the job's attributes at the end of your procedure.