[Home] [Help] [Dependency Information]
Object Name: | JOB |
---|---|
Object Type: | TYPE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
JOB_NAME | VARCHAR2 | (100) | |
JOB_CLASS | VARCHAR2 | (32) | |
JOB_STYLE | VARCHAR2 | (11) | |
JOB_TEMPLATE | VARCHAR2 | (100) | |
PROGRAM_ACTION | VARCHAR2 | (4000) | |
ACTION_TYPE | VARCHAR2 | (20) | |
SCHEDULE_NAME | VARCHAR2 | (65) | |
REPEAT_INTERVAL | VARCHAR2 | (4000) | |
SCHEDULE_LIMIT | INTERVAL DAY TO SECOND |
|
2 |
START_DATE | TIMESTAMP WITH TZ |
|
|
END_DATE | TIMESTAMP WITH TZ |
|
|
EVENT_CONDITION | VARCHAR2 | (4000) | |
QUEUE_SPEC | VARCHAR2 | (100) | |
NUMBER_OF_ARGS | NUMBER |
|
|
ARGUMENTS | JOBARG_ARRAY |
|
|
PRIORITY | NUMBER |
|
|
JOB_WEIGHT | NUMBER |
|
|
MAX_RUN_DURATION | INTERVAL DAY TO SECOND |
|
2 |
MAX_RUNS | NUMBER |
|
|
MAX_FAILURES | NUMBER |
|
|
LOGGING_LEVEL | NUMBER |
|
|
RESTARTABLE | VARCHAR2 | (5) | |
STOP_ON_WINDOW_EXIT | VARCHAR2 | (5) | |
RAISE_EVENTS | NUMBER |
|
|
COMMENTS | VARCHAR2 | (240) | |
AUTO_DROP | VARCHAR2 | (5) | |
ENABLED | VARCHAR2 | (5) | |
FOLLOW_DEFAULT_TZ | VARCHAR2 | (5) | |
PARALLEL_INSTANCES | VARCHAR2 | (5) | |
AQ_JOB | VARCHAR2 | (5) | |
INSTANCE_ID | NUMBER |
|
Name | Parameters | Result |
---|---|---|
JOB |
SELF(JOB) JOB_NAME(VARCHAR2) JOB_STYLE(VARCHAR2) JOB_TEMPLATE(VARCHAR2) PROGRAM_ACTION(VARCHAR2) ACTION_TYPE(VARCHAR2) SCHEDULE_NAME(VARCHAR2) REPEAT_INTERVAL(VARCHAR2) EVENT_CONDITION(VARCHAR2) QUEUE_SPEC(VARCHAR2) START_DATE(TIMESTAMP WITH TZ) END_DATE(TIMESTAMP WITH TZ) NUMBER_OF_ARGS(PL/SQL BINARY INTEGER) ARGUMENTS(JOBARG_ARRAY) JOB_CLASS(VARCHAR2) SCHEDULE_LIMIT(INTERVAL DAY TO SECOND) PRIORITY(PL/SQL BINARY INTEGER) JOB_WEIGHT(PL/SQL BINARY INTEGER) MAX_RUN_DURATION(INTERVAL DAY TO SECOND) MAX_RUNS(PL/SQL BINARY INTEGER) MAX_FAILURES(PL/SQL BINARY INTEGER) LOGGING_LEVEL(PL/SQL BINARY INTEGER) RESTARTABLE(PL/SQL BOOLEAN) STOP_ON_WINDOW_EXIT(PL/SQL BOOLEAN) RAISE_EVENTS(PL/SQL BINARY INTEGER) COMMENTS(VARCHAR2) AUTO_DROP(PL/SQL BOOLEAN) ENABLED(PL/SQL BOOLEAN) FOLLOW_DEFAULT_TZ(PL/SQL BOOLEAN) PARALLEL_INSTANCES(PL/SQL BOOLEAN) AQ_JOB(PL/SQL BOOLEAN) INSTANCE_ID(PL/SQL BINARY INTEGER) |
JOB |
|
|
|