Column name

Description

Id

ID of the process schedule.

Name

User-defined name for the process schedule.

Enabled

Status of the process schedule:

0 = Not enabled.

1 = Enabled.

If the schedule is not enabled, no process will run on the schedule.

FrequencyType

How frequently a process runs for this schedule.

1 = Daily

2 = Weekly

4 = Monthly

FrequencyInterval

Days that the job is executed. Depends on the value of FrequencyType. The default value is 0, which indicates that FrequencyInterval is unused.

Value of FrequencyType

Effect on FrequencyInterval

1 (daily)

Every FrequencyInterval days

2 (weekly)

FrequencyInterval is one or more of the following:

1 = Sunday

2 = Monday

4 = Tuesday

8 = Wednesday

16 = Thursday

32 = Friday

64 = Saturday

3 (monthly)

On the FrequencyInterval day of the month

FrequencySubType

Units for the FrequencySubInterval. Can be one of the following values:

Value

Description (unit)

1

At the specified time

2

Seconds

3

Minutes

4

Hours

FrequencySubInterval

Number of FrequencySubType periods to occur between each execution of the job.

LastRunDate

Date and Time for the last completed process execution.

LastRunStatus

Status for the last completed process execution.

false = Last execution failed.

true = Last execution succeeded.