Scheduler

Question 1

What view would show you the list of scheduled jobs?

Answer 1

DBA_SCHEDULER_JOBS

Question 2

What role is required for managing the scheduler?

Answer 2

SCHEDULER_ADMIN role

Question 3

Job States

Answer 3

Disabled - not scheduled
Retry Scheduled - failed but retry scheduled
Scheduled -
Running
Completed - done and not scheduled to run again
Broken - max failures reached, wont retry until fixed
Failed - all retries have failed regardless of max retries
Remote - running remotely
Succeeded -
Chain_Stalled - as a result of a dependency issue

Question 4

What package allows working with the scheduler?

Answer 4

DBMS_SCHEDULER
For exmaple:
exec DBMS_SCHEDULER.CREATE_JOB_CLASS
(job_class_name=’thisjob’);