A JOB Created With DBMS_SCHEDULER Without Specifying Any Start_date Gets Executed When Enabling it
(Doc ID 2401293.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.2 to 12.2]
Information in this document applies to any platform.
There is an old job that was in DISABLED status and had no start date, no end date. However, during a weekend activity this job as enabled by mistake by a script, and then the job started.
We thought that not having a START DATE, an END DATE and a FREQUENCY a job would have not been started by oracle even if enabled.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!