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.
Explanation:
auto_drop, If TRUE (the default), indicates that the job should be dropped once completed.
end_date, This attribute 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.