DBMSSCHEDULER.LOGGINGRUNS writes detailed information to job log for all runs of each job in the class

Q.  In controlling the job logging, which class is used for the scheduler to write detailed information to the job log for all runs of each job in this class?
- Published on 12 Aug 15

a. DBMS_SCHEDULER.LOGGING_RUNS
b. DBMS_SCHEDULER.LOGGING_FULL
c. DBMS_SCHEDULER.LOGGING_OFF
d. None of the above

ANSWER: DBMS_SCHEDULER.LOGGING_RUNS

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 24 Aug 15
    -You can control how frequently information is written to the job log by setting the logging_level attribute of either a job or a job class

    -Following are some of the classes for controlling the job logging

    -DBMS_SCHEDULER.LOGGING_RUNS - A log entry is made each time the job is run.

    -DBMS_SCHEDULER.LOGGING_FULL - A log entry is made every time the job runs and for every operation performed on a job, including create, enable/disable, update (with SET_ATTRIBUTE), stop, and drop.

    DBMS_SCHEDULER.LOGGING_OFF - No logging is performed.

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