Footprints Data Model

Table
Name job_cfg_dtl
Comment
The job configuration details that will be used to create jobs on the job
scheduler.

Column
Name Datatype Comment Is PK Is FK
job_cfg_dtl_id bigint The automatically generated primary key of the job_cfg_dtl table. Yes No
job_schdlr_cfg_id bigint A Foreign Key to the Job Scheduler Configuration table. No Yes
job_name varchar(100) The name of the job No No
job_class VARCHAR(150) The java class name of the job No No
grp_name varchar(100) Used for time based rules grouping. No No
trigger_type_name varchar(255)
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.
No No
trigger_start_date datetime The start date of scheduled running. Not required No No
trigger_end_date datetime Trigger End Date. No No
trigger_hour int The Hours portion of a time of day No No
trigger_minute int The minutes portion of a time of day No No
trigger_freq int
Numeric frequency.  e.g 15 in Minutely 15
No No
is_job_enabled bit False if disabled. No No
history_retain_days int Days to retain history of jobs before cleanup No No
history_retain_ct int Number of executions before cleanup. No No
job_parms varchar(max) Array of parameters used to pass to job. No No
create_date datetime The date that the Job Configuration Detail was created. No No
create_user varchar(255) User that created job No No
cron varchar(255)
For trigger type CRON JOB, the cron job arguments that will be passed on the
command line.
No No
repeat_ct int
0 if not used.  Can be set to a finite number.
No No
time_zone varchar(255) The value of a Job Configuration Detail, stored as a string. No No
ver_id bigint A Foreign Key to the Job Configuration Detail table. No No