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