PL/SQL API jcs_odf.alter_scheduler_queue
Summary
Alter a scheduler-queue combination.
Specification
procedure alter_scheduler_queue(scheduler_name in varchar2,
queue_name in varchar2,
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,
inclusive in varchar2 default const.def_str,
scheduler_partition in varchar2 default const.def_str,
queue_partition in varchar2 default const.def_str,
time_window_partition in varchar2 default const.def_str,
timezone_name in varchar2 default const.def_str)
Parameters
- scheduler_name - the name of the scheduler
- queue_name - the name 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 name of the time window during which the queue will release jobs
- inclusive - 'Y' or 'N': execution_size includes jobs with status WAITING
- scheduler_partition - the partition of the scheduler
- queue_partition - the partition of the queue
- time_window_partition - the partition of the time window during which the queue will release jobs
- timezone_name - the timezone this scheduler queue should be interpreted in if it is not defined the queue's timezone is used
See Also
- jcs_odf.create_scheduler
- jcs_odf.alter_scheduler
- jcs_odf.drop_scheduler
- jcs_odf.create_scheduler_queue
- jcs_odf.drop_scheduler_queue
plsqlTopic
onsiteTopic