PL/SQL API jcs_odf.create_submit_frame_element

Summary

• procedure create_submit_frame_element(submit_frame_name in varchar2, element in number, time_window_name in varchar2, every_minute in number, every_day in number, every_month in number, original_time in varchar2, submit_frame_partition in varchar2, time_window_partition in varchar2, starttime in varchar2, timezone_name in varchar2) ( (p_every_minute is null and p_every_day is null and p_every_month is null) is unsupported. )

Create a submit frame element.

Specification

procedure create_submit_frame_element(submit_frame_name in varchar2,
element in number default const.def_num,
time_window_name in varchar2 default const.def_str,
every_minute in number default const.def_num,
every_day in number default const.def_num,
every_month in number default const.def_num,
original_time in varchar2 default const.jcs_no,
submit_frame_partition in varchar2 default const.def_str,
time_window_partition in varchar2 default const.def_str,
starttime in varchar2 default const.def_str,
timezone_name in varchar2 default const.def_str)

Parameters

• submit_frame_name - name of the submit frame
• element - number of the submit frame element
• time_window_name - name of the time window during which the time element of the submit frame is valid
• every_minute - interval in minutes (max 9999)
• every_day - interval in days (max 9999)
• every_month - interval in months (max 24)
• original_time - use the original starting time of a job for every restart
• submit_frame_partition - the partition of the submit frame
• time_window_partition - partition of the time window during which the time element of the submit frame is valid
• starttime - explicitly defined starttime - input format is 'HH:MI' (24-hours)
• timezone_name - timezone in which starttime must be interpreted

note

You can specify at most one of every_minute, every_day or every_month. If you want to use the 'EVERY OPENING OF' syntax all three of these elements must be null.

See Also

• jcs_odf.create_submit_frame
• jcs_odf.alter_submit_frame
• jcs_odf.drop_submit_frame
• jcs_odf.drop_submit_frame_element

plsqlTopic

onsiteTopic