which jobs are currently executing?

Which Scheduler view(s) can be queried to see which jobs are currently executing? (Choose
all that apply.)

Which Scheduler view(s) can be queried to see which jobs are currently executing? (Choose
all that apply.)

A.
DBA_SCHEDULER_JOB_RUN_DETAILS

B.
DBA_SCHEDULER_RUNNING_JOBS

C.
DBA_SCHEDULER_CURRENT_JOBS

D.
DBA_SCHEDULER_JOBS

E.
DBA_SCHEDULER_EXECUTING_JOBS

Explanation:
DBA_SCHEDULER_JOB_RUN_DETAILS displays log run details for all Scheduler jobs in
the database. DBA_SCHEDULER_RUNNING_JOBS displays information about all running
Scheduler jobs in the database.
DBA_SCHEDULER_JOBS displays information about all Scheduler jobs in the database.
DBA_SCHEDULER_CURRENT_JOBS is INVALID.
DBA_SCHEDULER_EXECUTING_JOBS is INVALID.

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

Jake from SF

Jake from SF

B and D are correct:

https://docs.oracle.com/cd/B14117_01/server.101/b10755/statviews_2311.htm
For B:
DBA_SCHEDULER_RUNNING_JOBS displays information about all running Scheduler jobs in the database. Its columns are the same as those in ALL_SCHEDULER_RUNNING_JOBS.

https://docs.oracle.com/cd/B12037_01/server.101/b10755/statviews_2308.htm

For D: DBA_SCHEDULER_JOBS displays information about all Scheduler jobs in the database. Its columns are the same as those in ALL_SCHEDULER_JOBS.

Reply