Change Status
It describes the Change Status of Advanced Queue (AQ).
Execute AQ > Context Menu > Change Status to modify the status of the Advanced Queue object.
The users can set the details through each option, and check the SQL applied to the settings in the SQL area at the bottom.
Schema
The Schema of the AQ
Name
The name of the AQ
Status to Change
Selects whether to enable the Enqueue or Dequeue feature of the AQ.
Detail settings
Enqueue: Selects whether to enable/disable the Enqueue feature.
Dequeue: Selects whether to enable/disable the Dequeue feature.
Response to outstanding transactions: Specifies whether to wait for a transaction currently in progress.
After completing the detailed settings for each option, click [OK button] to apply the settings.
Last updated