[Home] [Help] [Dependency Information]
Object Name: | JOB_DEFINITION |
---|---|
Object Type: | TYPE |
Owner: | SYS |
Subobject Name: | $VSN_1 |
Status: | VALID |
Object Name: | JOB_DEFINITION |
---|---|
Object Type: | TYPE |
Owner: | SYS |
Subobject Name: | $VSN_2 |
Status: | VALID |
Object Name: | JOB_DEFINITION |
---|---|
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 | (17) | |
PROGRAM_NAME | VARCHAR2 | (100) | |
JOB_ACTION | VARCHAR2 | (4000) | |
JOB_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_ARGUMENTS | NUMBER |
|
|
ARGUMENTS | JOBARG_ARRAY |
|
|
JOB_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_CLOSE | VARCHAR2 | (5) | |
RAISE_EVENTS | NUMBER |
|
|
COMMENTS | VARCHAR2 | (240) | |
AUTO_DROP | VARCHAR2 | (5) | |
ENABLED | VARCHAR2 | (5) | |
FOLLOW_DEFAULT_TIMEZONE | VARCHAR2 | (5) | |
PARALLEL_INSTANCES | VARCHAR2 | (5) | |
AQ_JOB | VARCHAR2 | (5) | |
INSTANCE_ID | NUMBER |
|
|
CREDENTIAL_NAME | VARCHAR2 | (65) | |
DESTINATION | VARCHAR2 | (4000) | |
DATABASE_ROLE | VARCHAR2 | (20) | |
ALLOW_RUNS_IN_RESTRICTED_MODE | VARCHAR2 | (5) | |
RESTART_ON_RECOVERY | VARCHAR2 | (5) | |
RESTART_ON_FAILURE | VARCHAR2 | (5) | |
CONNECT_CREDENTIAL_NAME | VARCHAR2 | (65) | |
STORE_OUTPUT | VARCHAR2 | (5) |
Name | Parameters | Result |
---|---|---|
JOB_DEFINITION |
SELF(JOB_DEFINITION) JOB_NAME(VARCHAR2) JOB_STYLE(VARCHAR2) PROGRAM_NAME(VARCHAR2) JOB_ACTION(VARCHAR2) JOB_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_ARGUMENTS(PL/SQL BINARY INTEGER) ARGUMENTS(JOBARG_ARRAY) JOB_CLASS(VARCHAR2) SCHEDULE_LIMIT(INTERVAL DAY TO SECOND) JOB_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_CLOSE(PL/SQL BOOLEAN) RAISE_EVENTS(PL/SQL BINARY INTEGER) COMMENTS(VARCHAR2) AUTO_DROP(PL/SQL BOOLEAN) ENABLED(PL/SQL BOOLEAN) FOLLOW_DEFAULT_TIMEZONE(PL/SQL BOOLEAN) PARALLEL_INSTANCES(PL/SQL BOOLEAN) AQ_JOB(PL/SQL BOOLEAN) INSTANCE_ID(PL/SQL BINARY INTEGER) CREDENTIAL_NAME(VARCHAR2) DESTINATION(VARCHAR2) DATABASE_ROLE(VARCHAR2) ALLOW_RUNS_IN_RESTRICTED_MODE(PL/SQL BOOLEAN) RESTART_ON_RECOVERY(PL/SQL BOOLEAN) RESTART_ON_FAILURE(PL/SQL BOOLEAN) CONNECT_CREDENTIAL_NAME(VARCHAR2) STORE_OUTPUT(PL/SQL BOOLEAN) |
JOB_DEFINITION |
|
|
|