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 |