BatchProcessSchedule Table

BatchProcessSchedule stores the schedule of a batch process.

Table 1. Database columns for BatchProcessSchedule table

Database Column

Details

BatchProcessScheduleID

Type: integer. Key. Generated ID

A unique identifier for this table.

BatchProcessTypeID

Type: integer. Key

The process type ID this schedule belongs to. Foreign key to the BatchProcessType table.

TenantUID

Type: text (max 40 characters). Key. Nullable

The tenant UID for this batch schedule.

BatchProcessScheduleData

Type: text

The Quartz scheduler data

UpdatedBy

Type: text (max 200 characters). Nullable

The last operator to update the event.

UpdatedDate

Type: datetime. Nullable

The date the event was last updated.

GUID

Type: unique identifier. Key

Unique identifier for schedule.

LastRun

Type: datetime. Nullable

The datetime this schedule was last executed.

Enabled

Type: boolean

Whether this schedule is enabled or not. If this is set to False the schedule will not be executed.