|
SCHEMA |
VARCHAR2(30) |
NOT NULL |
The schema |
|
QNAME |
VARCHAR2(30) |
NOT NULL |
Source queue name |
|
DESTINATION |
VARCHAR2(128) |
NOT NULL |
Destination name, currently limited to be a DBLINK name |
|
START_DATE |
DATE |
|
Date to start propagation in the default date format |
|
START_TIME |
VARCHAR2(8) |
|
Time of day at which to start propagation in HH:MI:SS format |
|
PROPAGATION_WINDOW |
NUMBER |
|
Duration in seconds for the propagation window |
|
NEXT_TIME |
VARCHAR2(200) |
|
Function to compute the start of the next propagation window |
|
LATENCY |
NUMBER |
|
Maximum wait time to propagate a message during the propagation window |
|
SCHEDULE_DISABLED |
VARCHAR2(1) |
|
N if enabled; Y if disabled and schedule will not be executed |
|
PROCESS_NAME |
VARCHAR2(8) |
|
The name of the process executing the schedule. NULL if not currently executing |
|
SESSION_ID |
NUMBER |
|
The session ID (SID, SERIAL#) of the job executing this schedule. NULL if not currently executing |
|
INSTANCE |
NUMBER |
|
The OPS instance number executing the schedule |
|
LAST_RUN_DATE |
DATE |
|
The date on the last successful execution |
|
LAST_RUN_TIME |
VARCHAR2(8) |
|
The time of the last successful execution in HH:MI:SS format |
|
CURRENT_START_DATE |
DATE |
|
The date at which the current window of this schedule was started |
|
CURRENT_START_TIME |
VARCHAR2(8) |
|
The time of day at which the current window of this schedule was started in HH:MI:SS format |
|
NEXT_RUN_DATE |
DATE |
|
The date at which the next window of this schedule will be started |
|
NEXT_RUN_TIME |
VARCHAR2(8) |
|
The time of day at which the next window of this schedule will be started in HH:MI:SS format |
|
TOTAL_TIME |
NUMBER |
|
The total time, in seconds, spent by the system in executing this schedule |
|
TOTAL_NUMBER |
NUMBER |
|
The total number of messages propagated in this schedule |
|
TOTAL_BYTES |
NUMBER |
|
The total number of bytes propagated in this schedule |
|
MAX_NUMBER |
NUMBER |
|
The maximum number of messages propagated in a propagation window |
|
MAX_BYTES |
NUMBER |
|
The maximum number of bytes propagated in a propagation window |
|
AVG_NUMBER |
NUMBER |
|
The average number of messages propagated in a propagation window |
|
AVG_SIZE |
NUMBER |
|
The average size of a propagated message in bytes |
|
AVG_TIME |
NUMBER |
|
The average time, in seconds, to propagate a message |
|
FAILURES |
NUMBER |
|
The number of times the execution failed. If 16, the schedule will be disabled |
|
LAST_ERROR_DATE |
DATE |
|
The date of the last unsuccessful execution |
|
LAST_ERROR_TIME |
VARCHAR2(8) |
|
The time of the last unsuccessful execution |
|
LAST_ERROR_MSG |
VARCHAR2(4000) |
|
The error number and error message text of the last unsuccessful execution |
