The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE
The job will only be disabled if the value of the AUTO_DROP attribute is FALSE
The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE
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
The STATE column of the job table will be set to COMPLETED for the job