You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed tim

Question

Options

• AIncreasing the priority of the job class to which the job belongs
• BIncreasing the job's relative priority within the Job class to which it belongs
• CIncreasing the resource allocation for the consumer group mapped to the scheduler job's job
• DMoving the job to an existing higher priority scheduler window with the same schedule and
• EIncreasing the value of the JOB_QUEUE_PROCESSES parameter
• FIncreasing the priority of the scheduler window to which the job belongs

• A
  21% (10)
• B
  57% (27)
• D
  4% (2)
• E
  11% (5)
• F
  6% (3)

Explanation

B: Job priorities are used only to prioritize among jobs in the same class. Note: Group jobs for prioritization Within the same job class, you can assign priority values of 1-5 to individual jobs so that if two jobs in the class are scheduled to start at the same time, the one with the higher priority takes precedence. This ensures that you do not have a less important job preventing the timely completion of a more important one. C: Set resource allocation for member jobs Job classes provide the link between the Database Resource Manager and the Scheduler, because each job class can specify a resource consumer group as an attribute. Member jobs then belong to the specified consumer group and are assigned resources according to settings in the current resource plan.

No community discussion yet for this question.