PL/SQL API jcs_odf.create_scheduler_file_event

Summary

procedure create_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)

Create a scheduler-file-event combination.

Specification

procedure create_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