Databases Reference
In-Depth Information
The resulting schedule will include the first day of each month, except January 1st. It
must be pointed out that the FIRST_MONTH_DAY_SCHED schedule is defined to run at
08:00 a.m., meanwhile Jan 1 does not have a defined time.
Excluded dates without a time component are treated as twenty four
hour periods. All timestamps that fall on an excluded date are removed.
Considering the previously detailed expression:
FREQ=MONTHLY;BYMONTHDAY=1;BYHOUR=8;EXCLUDE=JAN_FIRST
All instances of the job are removed for Jan 01.
COMBINED SCHEDULE - EXCLUDE
FIRST_MONTH_DAY_SCHED
JAN_FIRST
Feb 1st
Mar 1st
Apr 1st
May 1st
Jul 1st
Sep 1st
Jun 1st
Aug 1st
Jan 1st
Oct 1st
Nov 1st
Dec 1st
FREQ=MONTHLY; BYMONTHDAY=1; BYHOUR=8; EXCLUDE=JAN_FIRST
Include scenario
In this scenario two schedules are defined, the first one defines several holidays, and
the second one defines a maintenance schedule that is meant to run every Sunday
and on holidays. If a given date is both a Sunday and a holiday, the scheduled task is
meant to run only once.
 
Search WWH ::




Custom Search