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 |
|
VARCHAR2(82) |
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) |