Timeline for Executing stored procedures in oracle inside a package using dbms_job
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 31, 2017 at 15:25 | answer | added | kevinskio | timeline score: 1 | |
| Jan 31, 2017 at 10:46 | comment | added | Andrew Brennan | Yeah try running the job immediately to see what the problem is. Also, Oracle 9 went out of support in 2006... | |
| Jan 31, 2017 at 9:29 | comment | added | BriteSponge | Its a while since I used 9i but have you tried the start_date as SYSDATE + 1/1440 ? Also check in DBA_JOBS for what Oracle believes has been set for the job and to check it isn't 'BROKEN'. Then try DBMS_JOB.RUN to force it to run. At least you'll know if its runnable. | |
| Jan 31, 2017 at 6:26 | history | edited | user1822 |
edited tags
|
|
| Jan 31, 2017 at 6:19 | review | First posts | |||
| Jan 31, 2017 at 7:48 | |||||
| Jan 31, 2017 at 6:17 | history | asked | zlatan | CC BY-SA 3.0 |