rs_queues
The following table lists the columns for the rs_queues view. The equivalent jcs_queues view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.
| Column | Datatype | Description |
| ID | NUMBER | The unique id of a queue |
| PARTITION | VARCHAR2 | The partition of a queue |
| NAME | VARCHAR2 | The name of a queue |
| VERSION | NUMBER | The version number of a queue |
| DESCRIPTION | VARCHAR2 | The description of a queue |
| APPLICATION_PARTITION | VARCHAR2 | The partition of the application; can be used to group Redwood objects in logical groups |
| APPLICATION_NAME | VARCHAR2 | The name of the application; can be used to group Redwood objects in logical groups |
| EXECUTION_SIZE | NUMBER | The number of concurrent jobs in the queue |
| STATUS | VARCHAR2 | The status of a queue: O=open, C=closed |
| HOLD | VARCHAR2 | Is this queue closed (Y or N)? |
| HOLD_LEVEL | NUMBER | In the queue, jobs having a priority below the specified number will not be started |
| HOLD_ABOVE_CPU_LOAD | NUMBER | In the queue, no jobs will be started when the CPU load exceeds the specified level |
| HOLD_ABOVE_PAGE_RATE | NUMBER | In the queue, no jobs will be started when the memory page rate exceeds the specified level |
| TIME_WINDOW_PARTITION | VARCHAR2 | The partition of the time window of the queue |
| TIME_WINDOW_NAME | VARCHAR2 | The name of the time window of the queue |
| NEXT_WINDOW_CHANGE | TIMESTAMP WITH TIME ZONE | The next date on which the time window will open or close the queue againThe timezone is specified as an Olson name. |
| STATUS_DESCRIPTION | VARCHAR2 | The description of the queue status |
| OVERDUE | VARCHAR2 | Set scripts that are not run within their timewindow to OVERDUE? |
| COMMENT_TEXT | VARCHAR2 | Comment describing the queue |
| RUNNING_JOBS | NUMBER | Current number of running jobs for this queue |
| INCLUSIVE | VARCHAR2 | If true, the queue size includes waiting jobs |
| INCLUSIVE_CONSOLE_JOBS | ||
| TIMEZONE_NAME | VARCHAR2 | The timezone for this time window |
note
VERSION: Version is not increased with one anymore after changing the object.
plsqlTopic
onsiteTopic