Hi Team,
Assume we have TABLE A with four columns as shown in above screenshot.
For every Store, I need to schedule job using dbms_job.submit where the interval has to change dynamically for every frequency as given in above column.
E.g: For Store "R001" the job should run for every 50sec, similarly for store "R004", the job should run for every 30 sec.. and so on..
Is there a way the above requirement can be achieved.
Please suggest.