Job execution steps - Oracle DBA

Q.  When a job is picked for processing, select the correct order in which job executes.

1. Starts a database session as the owner of the job, starts a transaction, and then starts executing the job.
2. Gathers all the metadata needed to run the job. As an example, arguments of the program and privilege information.
3. Once the job is complete, the slave commits and ends the transaction.
4. Closes the session

- Published on 12 Aug 15

a. 1, 2, 3, 4
b. 2, 1, 3, 4
c. 2, 3, 1, 4
d. 1, 3, 2, 4

ANSWER: 2, 1, 3, 4
 

    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.

    -When a job is picked for processing, the job slave executes in the following manner

    -Gathers all the metadata needed to run the job. As an example, arguments of the program and privilege information.
    -Starts a database session as the owner of the job, starts a transaction, and then starts executing the job.
    -Once the job is complete, the slave commits and ends the transaction.
    -Closes the session.

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