PL/SQL API jcs_odf.create_scheduler

Summary

• procedure create_scheduler(name in varchar2, description in varchar2, cpu_weight in number, job_weight in number, dispatcher_weight in number, comment_text in varchar2, application_name in varchar2, type in varchar2, startup_cmd in varchar2, keep_until in varchar2, configuration in varchar2, partition in varchar2, application_partition in varchar2, nt_service_name in varchar2, execution_size in number, os_user in varchar2, starttype in varchar2, odf_weight in number, db_user in varchar2, hold_delete in varchar2) (Parameter cpu_weight is unsupported. Parameter job_weight is unsupported. Parameter dispatcher_weight is unsupported. Parameter type is unsupported. Parameter startup_cmd is unsupported. Parameter keep_until is unsupported. Parameter configuration is unsupported. Parameter application_partition is unsupported. Parameter nt_service_name is unsupported. Parameter os_user is unsupported. Parameter starttype is unsupported. Parameter odf_weight is unsupported. Parameter db_user is unsupported. Parameter hold_delete is unsupported.)

Create a scheduler.

Specification

procedure create_scheduler(name in varchar2,
description in varchar2 default const.def_str,
cpu_weight in number default const.def_num,
job_weight in number default const.def_num,
dispatcher_weight in number default const.def_num,
comment_text in varchar2 default const.def_str,
application_name in varchar2 default const.def_str,
type in varchar2 default const.def_str,
startup_cmd in varchar2 default const.def_str,
keep_until in varchar2 default const.def_str,
configuration in varchar2 default const.def_str,
partition in varchar2 default const.def_str,
application_partition in varchar2 default const.def_str,
nt_service_name in varchar2 default const.def_str,
execution_size in number default const.def_num,
os_user in varchar2 default const.def_str,
starttype in varchar2 default const.def_str,
odf_weight in number default const.def_num,
db_user in varchar2 default const.def_str,
hold_delete in varchar2 default const.def_str)

Parameters

• name - the name of the scheduler
• description - a description for the scheduler
• cpu_weight - the CPU load of the process server host is multiplied by cpu_weight in load balancing calculations
• job_weight - the number of jobs running on the host of the process server is multiplied by job_weight in load balancing calculations
• dispatcher_weight - the dispatcher agent is located on the process server with the highest dispatcher_weight. A process server with a higher dispatcher_weight than another process server is more suitable to run the dispatcher agent.
• comment_text - a comment with the scheduler
• application_name - the name of the application the scheduler belongs to
• type - the type of scheduler, 'NATIVE' or 'JAVA'
• startup_cmd - the startup command for a java scheduler
• keep_until - how long will the scheduler trace files will be kept on the server - null means unlimited. This must be an Oracle date expression
• configuration - configuration string for the scheduler
• partition - the partition of the scheduler
• application_partition - the partition of the application the scheduler belongs to
• nt_service_name - if this is filled and the scheduler runs on Windows NT it specifies the name of the service connected to this scheduler
• execution_size - the maximum number of concurrent jobs in the queue (with status RUNNING, WAITING or CONSOLE)
• os_user - the OS user starting the NT service (null for localsystem account)
• starttype - the starttype of the related NT service (MANUAL or AUTOMATIC)
• odf_weight - the preference to execute Redwood explorer commands
• db_user - the Oracle user that the MA uses to log into the database
• hold_delete - should the delete agent run?

note

The scheduler type depends on the startup command: when the startup command is empty, the scheduler type is 'NATIVE', otherwise it is 'JAVA'. You cannot edit the scheduler_type directly.

See Also

• jcs_odf.alter_scheduler
• jcs_odf.drop_scheduler
• jcs_odf.create_scheduler_queue
• jcs_odf.alter_scheduler_queue
• jcs_odf.drop_scheduler_queue
• jcs_odf.create_scheduler_resource
• jcs_odf.drop_scheduler_resource
• jcs_odf.create_scheduler_file_event
• jcs_odf.alter_scheduler_file_event
• jcs_odf.drop_scheduler_file_event
• jcs_odf.create_scheduler_scripttype
• jcs_odf.drop_scheduler_scripttype

plsqlTopic

onsiteTopic