I have 6 stored procedures that I want to execute at the same time I want to kick it off so the execution starts and then I want to execute all 6 after 20 minutes.
I have written the following scheduler. Should this procedure kick off at start_date => v_start_date(sysdate), and thus execute every 20 minutes. Or having the dbms_scheduler.create_job not enough, Do we need anything else for the scheduler to start(execute).
My Main issue is that I have 5 more stored procs like 'LOAD_APPLICATION_PKG.Refresh_X_Dim and I want all 6 to be exucuted at the same time and refresh every 20 minutes, same time.
This particular assignment
v_job_action := 'begin ' || 'LOAD_APPLICATION_PKG.Refresh_X_Dim;
schedules 'LOAD_APPLICATION_PKG.Refresh_X_Dim' to execute, can te other five stored procs be added so they all get processed parallelly(run at the same time)