usecurrentsession=true run the job synchronously with RUNJOB - Oracle DBA

Q.  You can run the job synchronously with RUN_JOB by setting which of the following argument.
- Published on 27 Jul 15

a. use_current_session=true
b. use_current_session=flase
c. Both A and B can be set
d. failure_count=true

ANSWER: use_current_session=true

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 26 Aug 15
    -You can run a job synchronously with RUN_JOB by setting the use_current_session argument to TRUE.

    -Here the job runs within the user session that invokes RUN_JOB instead of being run by a job slave.

    -The session that calls RUN_JOB blocks until the job completes.

    -Running a job synchronously with RUN_JOB does not change the failure_count and run_count for the job.

    -The job run is, however, reflected in the job log.

    -Runtime errors generated by the job are passed back to the invoker of RUN_JOB.

    -When using RUN_JOB to run a remote external job or a job that points to a chain, use_current_session must be set to FALSE.

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