Database Administration (MOSC)

MOSC Banner

Scheduler 11.2.0.3 : how to interpret column LOG_ID of the ALL_SCHEDULER_RUNNING_JOBS view

edited Dec 10, 2013 2:27AM in Database Administration (MOSC) 4 commentsAnswered
Hi,
After submitting a scheduler job with the DBMS_SCHEDULER.RUN_JOB procedure, I'd like to retrieve the LOG_ID it will associate in the scheduler data dictionary views.
It seems there's no API available to do that, so I'm thinking of querying the ALL_SCHEDULER_RUNNING_JOBS as it contains a LOG_ID column. I can read the following in the documenation about this view:


LOG_ID   NUMBER   Log ID used for this running job. This column maps to the LOG_ID column of the *_SCHEDULER_JOB_LOG and *_SCHEDULER_JOB_RUN_DETAILS views.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center