Job slaves - Properties, Features - Oracle DBA

Q.  Job slaves actually execute the jobs you submit. When a job is done, what will the slave do?
- Published on 12 Aug 15

a. Reschedule the job if required
b. Update the state in the job table to reflect whether the job has completed or is scheduled to run again
c. Delete an entry into the job log table
d. Do not update the run count, and if necessary, failure count and retry count
e. Both A & B

ANSWER: Both A & B
 

    Discussion

  • Nirja Shah   -Posted on 24 Aug 15
    -Job slaves are the one which actually execute the jobs that you submit.

    -They are awakened by the job coordinator when it is time for a job to be executed.

    -They gather the metadata to run the job from the job table.

    -When a job is done the slaves execute the following activities:

    -Reschedule the job if required
    -Update the state in the job table to reflect whether the job has completed or is scheduled to run again
    -Insert an entry into the job log table
    -Update the run count, and if necessary, failure count and retry count
    -Clean up
    -Look for new work (if none, they go to sleep)

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