When a job exceeds the date specified in its END_DATE attribute, which of the following will
happen? (Choose all that apply.)
A.
The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE.
B.
The job will only be disabled if the value of the AUTO_DROP attribute is FALSE.
C.
The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP
attribute is FALSE.
D.
All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is
TRUE and the value of the CASCADE attribute is TRUE.
E.
The STATE column of the job table will be set to COMPLETED for the job.
Correct answer is A, B, and C.
auto_drop
This attribute, if TRUE, causes a job to be automatically dropped after it completes or is automatically disabled. 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.
A job is automatically disabled when it has failed max_failures times. max_failures is also set with SET_ATTRIBUTE.
If this attribute is set to FALSE, the jobs are not dropped and their metadata is kept until the job is explicitly dropped with the DROP_JOB procedure.
By default, jobs are created with auto_drop set to TRUE.
end_date
Specifies the date and time after which the job expires and is no longer run. After the end_date, if auto_drop is TRUE, the job is dropped. If auto_drop is FALSE, the job is disabled and the STATE of the job is set to COMPLETED.
If no value for end_date is specified, the job repeats forever unless max_runs or max_failures is set, in which case the job stops when either value is reached.
The value for end_date must be after the value for start_date. If it is not, an error is generated when the job is enabled.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_sched.htm#CIHDAIIH