*SCHEDULERJOBS - All jobs or both enabled & disabled - Oracle DBA

Q.  Which view shows that all the jobs or both enabled and disabled?
- Published on 12 Aug 15

a. *_SCHEDULER_JOBS
b. *_SCHEDULER_JOB_ROLES
c. *_SCHEDULER_PROGRAMS
d. *_SCHEDULER_JOB_RUN_DETAILS

ANSWER: *_SCHEDULER_JOBS
 

    Discussion

  • Nirja Shah   -Posted on 24 Aug 15
    -A job defines the action to perform, the schedule for the action, and the location or locations where the action takes place.

    -Most other scheduler objects are created to support jobs.

    -In the following views the asterisk at the beginning of a view name can be replaced with DBA, ALL, or USER.

    -*_SCHEDULER_JOBS - This view shows all the jobs,enabled as well as disabled.

    -*_SCHEDULER_JOB_ROLES - This view shows all the jobs by the Oracle Data Guard database role.

    -*_SCHEDULER_PROGRAMS - This view shows all the program.

    -*_SCHEDULER_JOB_RUN_DETAILS - This view shows all the jobs completed(failed or successful) job runs.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)