Which of the following is not a valid calendaring syntax element?
A.
FREQ
B.
BYHOUR
C.
RUNDATE
D.
INTERVAL
E.
BYMINUTE
Explanation:
Calendaring Syntax (link)
Table 129-10 Values for repeat_interval
FREQ
This specifies the type of recurrence. It must be specified. The possible predefined frequency values are
YEARLY, MONTHLY, WEEKLY, DAILY, HOURLY, MINUTELY, and SECONDLY. Alternatively, specifies an
existing schedule to use as a user-defined frequency.
INTERVAL
This specifies a positive integer representing how often the recurrence repeats. The default is 1, which means
every second for secondly, every day for daily, and so on. The maximum value is 99.
BYMONTH
This specifies which month or months you want the job to execute in. You can use numbers such as 1 for
January and 3 for March, as well as three-letter abbreviations such as FEB for February and JUL for July.
BYWEEKNO
This specifies the week of the year as a number. It follows ISO-8601, which defines the week as starting with
Monday and ending with Sunday; and the first week of a year as the first week, which is mostly within the
Gregorian year. The first week is equivalent to the following two variants: the week that contains the first
Thursday of the Gregorian year; and the week containing January 4th. The ISO-8601 week numbers are
integers from 1 to 52 or 53; parts of week 1 may be in the previous calendar year; parts of week 52 may be in
the following calendar year; and if a year has a week 53, parts of it must be in the following calendar year.
As an example, in the year 1998, the ISO week 1 began on Monday December 29th, 1997; and the last ISO
week (week 53) ended on Sunday January 3rd, 1999. So December 29th, 1997, is in the ISO week 1998-01,
and January 1st, 1999, is in the ISO week 1998-53.
byweekno is only valid for YEARLY. Examples of invalid specifications are “FREQ=YEARLY; BYWEEKNO=1;
BYMONTH=12″ and “FREQ=YEARLY; BYWEEKNO=53;BYMONTH=1”.
BYYEARDAY
This specifies the day of the year as a number. Valid values are 1 to 366. An example is 69, which is March 10
(31 for January, 28 for February, and 10 for March). 69 evaluates to March 10 for non-leap years and March 9
in leap years. -2 will always evaluate to December 30th independent of whether it is a leap year.
BYDATE
This specifies a list of dates, where each date is of the form [YYYY] MMDD. A list of consecutive dates can be
generated by using the SPAN modifier, and a date can be adjusted with the OFFSET modifier. An example of a
simple BYDATE clause follows: BYDATE=0115,0315,0615,0915,1215,20060115 The following SPAN example
is equivalent to BYDATE=0110,0111,0112,0113,0114, which is a span of 5 days starting at 1/10:
BYDATE=0110+SPAN:5D
The plus sign in front of the SPAN keyword indicates a span starting at the supplied date. The minus sign
indicates a span ending at the supplied date, and the “^” sign indicates a span of n days or weeks centered
around the supplied date. If n is an even number, it is adjusted up to the next odd number.
Offsets adjust the supplied date by adding or subtracting n days or weeks. BYDATE=0205-OFFSET: 2W is
equivalent to BYDATE=0205-14D (the OFFSET: keyword is optional), which is also equivalent to
BYDATE=0122.
BYMONTHDAY
This specifies the day of the month as a number. Valid values are 1 to 31. An example is 10, which means the
10th day of the selected month. You can use the minus sign (-) to count backward from the last day, so, for
example, BYMONTHDAY=-1 means the last day of the month and BYMONTHDAY=-2 means the next to last
day of the month.
BYDAY
This specifies the day of the week from Monday to Sunday in the form MON, TUE, and so on. Using numbers,
you can specify the 26th Friday of the year, if using a YEARLY frequency, or the 4th THU of the month, using a
MONTHLY frequency. Using the minus sign, you can say the second to last Friday of the month. For example, –
1 FRI is the last Friday of the month.
BYHOUR
This specifies the hour on which the job is to run. Valid values are 0 to 23. As an example, 10 means 10 a.m.
BYMINUTE
This specifies the minute on which the job is to run. Valid values are 0 to 59. As an example, 45 means 45
minutes past the chosen hour.BYSECOND
This specifies the second on which the job is to run. Valid values are 0 to 59. As an example, 30 means 30
seconds past the chosen minute.
BYSETPOS
This selects one or more items, by position, in the list of timestamps that result after the whole calendaring
expression is evaluated. It is useful for requirements such as running a job on the last workday of the month.
Rather than attempting to express this with the other BY clauses, you can code the calendaring expression to
evaluate to a list of every workday of the month, and then add the BYSETPOS clause to select only the last
item of that list. Assuming that workdays are Monday through Friday, the syntax would then be:
FREQ=MONTHLY; BYDAY=MON,TUE,WED,THU,FRI; BYSETPOS=-1
Valid values are 1 through 9999. A negative number selects an item from the end of the list (-1 is the last item, –
2 is the next to last item, and so on) and a positive number selects from the front of the list. The BYSETPOS
clause is always evaluated last. BYSETPOS is only supported with the MONTHLY and YEARLY frequencies.
The BYSETPOS clause is applied to the list of timestamps once per frequency period. For example, when the
frequency is defined as MONTHLY, the Scheduler determines all valid timestamps for the month, orders that
list, and then applies the BYSETPOS clause. The Scheduler then moves on to the next month and repeats the
procedure. Assuming a start date of Jun 10, 2004, the example evaluates to: Jun 30, Jul 30, Aug 31, Sep 30,
Oct 29, and so on.
INCLUDE
This includes one or more named schedules in the calendaring expression. That is, the set of timestamps
defined by each included named schedule is added to the results of the calendaring expression. If an identical
timestamp is contributed by both an included schedule and the calendaring expression, it is included in the
resulting set of timestamps only once. The named schedules must have been defined with the
CREATE_SCHEDULE procedure.
EXCLUDE
This excludes one or more named schedules from the calendaring expression. That is, the set of timestamps
defined by each excluded named schedule is removed from the results of the calendaring expression. The
named schedules must have been defined with the CREATE_SCHEDULE procedure.
INTERSECT
This specifies an intersection between the calendaring expression results and the set of timestamps defined by
one or more named schedules. Only the timestamps that appear both in the calendaring expression and in one
of the named schedules are included in the resulting set of timestamps. For example, assume that the named
schedule last_sat indicates the last Saturday in every month, and that for the year 2005, the only months where
the last day of the month is also a Saturday are April and December.
Assume also that the named schedule end_qtr indicates the last day of each quarter in 2005:
3/31/2005, 6/30/2005, 9/30/2005, 12/31/2005 These calendaring expressions result in the dates that follow:
3/31/2005, 4/30/2005, 6/30/2005, 9/30/2005, 12/31/2005
FREQ=MONTHLY; BYMONTHDAY=-1; INTERSECT=last_sat,end_qtr
In this example, the terms FREQ=MONTHLY; BYMONTHDAY=-1 indicate the last day of each month.
PERIODS
This identifies the number of periods that together form one cycle of a user-defined frequency. It is used in the
repeat_interval expression of the schedule that defines the user-defined frequency. It is mandatory when the
repeat_interval expression in the main schedule contains a BYPERIOD clause. The following example defines
the quarters of a fiscal year.
FREQ=YEARLY;BYDATE=0301,0601,0901,1201;PERIODS=4
BYPERIOD
This selects periods from a user-defined frequency. For example, if a main schedule names a user-defined
frequency schedule that defines the fiscal quarters shown in the previous example, the clause BYPERIOD=2,4
in the main schedule selects the 2nd and 4th fiscal quarters.