Data Dictionary
>
FPSAPP Views
> FPSAPP.WIP_WAFER_HIST_LOOP
View FPSADMIN.BLD_DBMS_SCHEDULER_JOB_SYNTAX
This view saves the tricky syntax needed to create, modify, drop, run, and view a job from DBMS_SCHEDULER. For complete details, see the excellent documentation at: https://docs.oracle.com/cd/E11882_01/server.112/e25494/scheduse.htm#ADMIN034 It is important to note that the repeat_interval is based on the start time of the previous run. Therefore the next scheduled execution time might arrive while the job is still running. If so, the new instance of the job will wait to start until the current one completes. There is no easy way to schedule based on the end time of the previous run.
|
Column |
Comment |
|---|---|
|
MESSAGE |