Footprints Data Model

Table
Table Name Job Configuration Detail
Table Definition The job configuration details that will be used to create jobs on the job scheduler.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Job Configuration Detail Id The automatically generated primary key of the job_cfg_dtl table. LONG Yes
Job Scheduler Configuration Id A Foreign Key to the Job Scheduler Configuration table. LONG Yes
Job Name The name of the job VARCHAR(100) No
Job Class The java class name of the job VARCHAR(150) No
Group Name Used for time based rules grouping. VARCHAR(100) No
Trigger Type Name Frequency type of trigger. eg Daily, Minutely, which can be qualified by the frequency. E.G. Minutely 15. Most jobs are controlled by Quartz, CRON jobs are controlled by the OS. VARCHAR(255) No
Trigger Start Date The start date of scheduled running. Not required DATE No
Trigger End Date Trigger End Date. DATE No
Trigger Hour The Hours portion of a time of day INTEGER No
Trigger Minute The minutes portion of a time of day INTEGER No
Trigger Frequency Numeric frequency. e.g 15 in Minutely 15 INTEGER No
Is Job Enabled False if disabled. BOOLEAN No
History Retain Days Days to retain history of jobs before cleanup INTEGER No
History Retain Count Number of executions before cleanup. INTEGER No
Job Parameters Array of parameters used to pass to job. TEXT No
Create Date The date that the Job Configuration Detail was created. DATE No
Create User User that created job VARCHAR(255) No
Cron For trigger type CRON JOB, the cron job arguments that will be passed on the command line. VARCHAR(255) No
Repeat Count 0 if not used. Can be set to a finite number. INTEGER No
Time Zone The value of a Job Configuration Detail, stored as a string. VARCHAR(255) No
Version ID A Foreign Key to the Job Configuration Detail table. LONG No