autodrop - Behavior controller - Oracle DBA

Q.  Jobs are database objects, and can therefore accumulate and take up too much space. To avoid this, job objects are automatically dropped by default after completion. This behavior is controlled by which job attribute?

- Published on 12 Aug 15

a. auto_view
b. auto_drop
c. auto_cancel
d. drop

ANSWER: auto_drop
 

    Discussion

  • Nirja Shah   -Posted on 21 Aug 15
    - The auto_drop is an job attribute which controls the behaviour of the job objects that are automatically by default after completion.

    - auto_drop - If it is TRUE(the default) it indicates that the job should be dropped once it is completed.

    -A job is considered completed if:

    Its end date (or its schedule's end date) has passed.

    It has run max_runs number of times. max_runs must be set with SET_ATTRIBUTE.

    It is not a repeating job and has run once.

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