System Tables: Schedule

From Explore Analytics: The Wiki
Jump to navigation Jump to search

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).