'How to run multipe Oracle DBMS_SCHEDULER jobs in same session asynchronously
Is it possible to run multiple dbms_scheduler jobs in same database session asynchronously?
The objective here is - Say we have two jobs JOB_1 and JOB_2 and they are modifying the same table. The data updated by JOB_1 (but not committed yet) should be available in JOB_2.
Any help is appreciated.
Thanks.
Solution 1:[1]
No.
Each job always runs in its own database session; when the session ends, its work is either committed or rolled back.
If you need the task for JOB_2 to see changes updated by JOB_1 but not yet committed, it must be run in the same transaction, which means they must be run in a single job.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Jeffrey Kemp |