System Tables: Schedule
Contents
Introduction
This table has records the describe a recurring schedule. A schedule belongs to a job.
Fields
In addition to the common fields, the Schedule Table includes the following fields
End Repeat
If specified, the job will stop recurring once the end repeat is reached. This is specified as a date and time.
Every
A number, default is 1, or time units between runs. For example, “2” for every 2 weeks.
Monthly By
If the job is monthly, possible choices are: specific weekday, day of the month, last day of the month.
Monthly Day
A number representing the day of the month.
Monthly Weekday Day
A day of the week, Sunday through Saturday
Monthly Weekday Ordinal
“first”, “second”, “third”, “fourth”, “last”
Name
Name of the schedule. This field is not used for user tasks.
Repeat
“daily”, “weekly” or “monthly”
Time Hours
Time of day hours: 0 to 23
Time Minutes
Time of day minutes: 0 to 59
Time Seconds
Time of day seconds: 0 to 59
Time Zone
The name of the time zone in which the dates and times in this schedule are specified.
Weekly Days
For a weekly schedule, a comma-separated list of names of days in which the job will run (e.g., every Tuesday and Thursday).