PL/SQL API jcs_odf.alter_scheduler_file_event

Summary

procedure alter_scheduler_file_event(scheduler_name in varchar2, file_name in varchar2, event_name in varchar2, move_directory in varchar2, test_unlocked in varchar2, check_interval in number, scheduler_partition in varchar2, event_partition in varchar2, status in varchar2)

Alter a scheduler-file-event combination.

The following properties can be modified:

event
move_directory
test_unlocked
check_interval
status

The scheduler_name, scheduler_partition and the file_name are part of the primary key and therefore cannot be altered. The event_name and event_partition are not and can be altered. The event_name, however, always needs to be specified, even when you don't want to change it.

Specification

procedure alter_scheduler_file_event(scheduler_name in varchar2,
file_name in varchar2,
event_name in varchar2,
move_directory in varchar2 default const.def_str,
test_unlocked in varchar2 default const.def_str,
check_interval in number default const.def_num,
scheduler_partition in varchar2 default const.def_str,
event_partition in varchar2 default const.def_str,
status in varchar2 default const.def_str)

Parameters

scheduler_name - the name of the scheduler
file_name - the name of the file
event_name - the name of the event
move_directory - the directory to move the files to
test_unlocked - 'Y' or 'N': perform extra lock testing
check_interval - set the check interval for the event on a per file basis, defined as the number of seconds between each check with a default value of 30
scheduler_partition - the partition of the scheduler
event_partition - the partition of the event
status - H(OLDING), S(TOPPED) or N(ORMAL)

note

Normally the process server event agent waits until the file is no longer locked by the operating system. However, some operating systems do not perform proper locking. In this case, set test_unlocked to 'Y' to force the process server to do extra lock testing.

Product Documentation