rs_queues
!ONSITEY!
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.