Scheduler Flashcards Preview

Oracle DB12c > Scheduler > Flashcards

Flashcards in Scheduler Deck (4)
Loading flashcards...
1
Q

What view would show you the list of scheduled jobs?

A

DBA_SCHEDULER_JOBS

2
Q

What role is required for managing the scheduler?

A

SCHEDULER_ADMIN role

3
Q

Job States

A

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

4
Q

What package allows working with the scheduler?

A

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