USER_QUEUES v17

The USER_QUEUES view provides information about any queue on which the current user has usage privileges.

NameTypeDescription
nameTEXTName of the queue.
queue_tableTEXTName of the queue table in which the queue resides.
qidOIDThe system-assigned object ID of the queue.
queue_typeCHARACTER VARYINGThe queue type. Can be EXCEPTION_QUEUE, NON_PERSISTENT_QUEUE, or NORMAL_QUEUE.
max_retriesNUMERICThe maximum number of dequeue attempts.
retrydelayNUMERICThe maximum time allowed between retries.
enqueue_enabledCHARACTER VARYINGYES if the queue allows enqueuing, NO if the queue does not.
dequeue_enabledCHARACTER VARYINGYES if the queue allows dequeuing, NO if the queue does not.
retentionCHARACTER VARYINGNumber of seconds that a processed message is retained in the queue.
user_commentCHARACTER VARYINGA user-specified comment.
network_nameCHARACTER VARYINGName of the network on which the queue resides.
shardedCHARACTER VARYINGYES if the queue resides on a sharded network, NO if the queue does not.