Hi All,
I have been involved with researching DBMS_Scheduler a lot these days. One of the requirement I am working on as is as follows. consider I have a table of records with data as described below
| dbms_log_id | Column1 | Column2 | Process_name | SYNC_STATUS |
|---|
| col1data | col2data | process1 | NOT_STARTED |
| col1data | col2data | process1 | NOT_STARTED |
| col1data | col2data | process2 | NOT_STARTED |
| col1data | col2data | process2 | NOT_STARTED |
In the above table, there are two DISTINCT processes namely process1 and process2. Probably at end of the day, we run a script that gets all the rows with sync_status = 'NOT_STARTED' and loop through them. In each loop, while the process 1 kicks a job, the other rows with the same process should not be started until the prior job is completed. But the rows with process 2 can run by kicking its corresponding job. All rows with process1 will run a job with name 'JOB_1' and all rows with process2 will run a job with job_2. Is there a way to put the jobs in queue so the prior jobs gets completed first?