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,091 5,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 userdefined 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.