jcs_odf.alter_queue

on-site-related topic PL/SQL API jcs_odf.alter_queue

Summary

Alter a Queue.

Note: This procedure does not add, remove or modify Process Servers serving this Queue. You can manage those by using jcs_odf.create_queue_scheduler, jcs_odf.alter_queue_scheduler and jcs_odf.drop_queue_scheduler.

Specification

Copy 
procedure alter_queue(name in varchar2,
description in varchar2 default const.def_str,
execution_size in number default const.def_num,
hold in varchar2 default const.def_str,
hold_level in number default const.def_num,
hold_above_cpu_load in number default const.def_num,
hold_above_page_rate in number default const.def_num,
time_window_name in varchar2 default const.def_str,
overdue in varchar2 default const.def_str,
version in number default null,
comment_text in varchar2 default const.def_str,
application_name in varchar2 default const.def_str,
inclusive in varchar2 default const.def_str,
partition in varchar2 default const.def_str,
time_window_partition in varchar2 default const.def_str,
application_partition in varchar2 default const.def_str,
timezone_name in varchar2 default const.def_str)

Parameters

  • name - the name of the Queue
  • description - the description of the Queue
  • execution_size - the maximum number of concurrent jobs in the Queue (with status RUNNING, WAITING or CONSOLE)
  • hold - 'Y' or 'N': the status on Queue creation
  • hold_level - hold jobs with a priority lower than the specified number
  • hold_above_cpu_load - hold jobs when the system CPU load exceeds the specified number
  • hold_above_page_rate - hold jobs when the memory paging rate exceeds the specified number
  • time_window_name - the Time Window during which the Queue will release jobs
  • overdue - set scripts that are not run within their Time Window to status OVERDUE
  • version - the version number of the Queue
  • comment_text - a text with comments on the Queue
  • application_name - the application the Queue belongs to
  • inclusive - 'Y' or 'N': execution_size includes jobs with status WAITING
  • partition - the Partition of the Queue
  • time_window_partition - the Partition of the Time Window during which the Queue will release jobs
  • application_partition - the Partition of the application the Queue belongs to
  • timezone_name - the timezone this Queue should be interpreted in

Note: Set execution_size to NULL to emulate the jcs 'SIZE UNLIMITED' phrase.

See Also