Specify a class, job will automatically become part of defaultjobclass - Oracle DBA

Q.  A job must be part of exactly one class. When you create a job, you can specify which class the job is part of. If you do not specify a class, the job will automatically become part of which class?
- Published on 30 Jul 15

a. default_job_class
b. job_class
c. job_over_max_dur
d. Both A and B

ANSWER: default_job_class
 

    Discussion

  • Nirja Shah   -Posted on 25 Aug 15
    -Jobs classes provide a way to group jobs for resource allocation and prioritization, and a way to easily assign a set of attribute values to member jobs.

    -DEFAULT_JOB_CLASS - There is a default job class that is created with the database.
    -If you create a job without specifying a job class, the job will be assigned to this default job class (DEFAULT_JOB_CLASS).
    -The default job class has the EXECUTE privilege granted to PUBLIC so any database user who has the privilege to create a job can create a job in the default job class.

    -job_over_max_dur - The job exceeded the maximum run duration specified by its max_run_duration attribute.

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.)