Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Finding out JOB information from inside procedure

zoffobMar 30 2015 — edited Mar 31 2015

Hellou ,

please I want to ask if somethink like this is possible:

I have procedure (in package or stand_alone). And this procedure was called by some JOB (this job can runs every for example 10 seconds). I want from inside this procedure (for example when it failes after few minutes) find out which JOB runs it and also all other informations about that JOB run from this tables (the best some job_log_id):

gather then data from this tables according the JOB_ID

SELECT * FROM dba_scheduler_job_run_details;

SELECT * FROM dba_scheduler_running_jobs;

How can I get the detail information about JOB that runs my procedure?

THX

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2015

Added on Mar 30 2015

#database-key-features, #scheduler

7 comments

1,907 views