Data Dictionary
>
FPSINPUT Tables
> FPSINPUT.DBF_SCHEDULER_JOBS
Table FPSINPUT.DBF_SCHEDULER_JOBS"
See comments in DBF_REF_SCHEDULER_JOBS view.
-
Schema: FPSINPUT
-
Tablespace: FPSDATA
-
Primary key: OWNER, JOB_NAME
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
OWNER |
VARCHAR2(30) |
N |
|
|
JOB_NAME |
VARCHAR2(128) |
N |
the name of the scheduled-job, should also include schema name (* from FPSAPP.SCH_W_LOGS_SCHED_JOBS) |
|
COMMENTS |
VARCHAR2(4000) |
A comment field allowing a user to document the source or reason of the values populated in the table (* from FPSAPP.GP_C_RSEC_PROCESS_ROUTE) |
|
|
DDL_SCOPE |
VARCHAR2(17) |
||
|
ENABLED |
VARCHAR2(5) |
||
|
JOB_ACTION |
VARCHAR2(4000) |
||
|
JOB_TYPE |
VARCHAR2(16) |
||
|
LAST_DDL_TIME |
DATE |
||
|
LAST_START_DATE |
DATE |
||
|
NEXT_RUN_DATE |
DATE |
||
|
REPEAT_INTERVAL |
VARCHAR2(4000) |
||
|
SCHEDULE_TYPE |
VARCHAR2(12) |
||
|
SCHEMA_REPOSITORY |
VARCHAR2(14) |