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