Subject Area : 120 - Job Scheduler
Subject Area Name Definition
120 - Job Scheduler The tables used to define the job scheduler instance and template for job configuration. Quartz is used to execute the background jobs.
ER Diagram Name Physical Display Level
Logical Column
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
job_cfg_dtl Job Configuration Detail false The job configuration details that will be used to create jobs on the job scheduler.
Physical Name Attribute/Column Name Definition Physical Data Type
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
job_schdlr_cfg Job Scheduler Configuration false An instance of job scheduler used for background job execution. Currently, the Quartz job scheduler is used. Usually one instance is sufficient.
Physical Name Attribute/Column Name Definition Physical Data Type
job_schdlr_cfg_id Job Scheduler Configuration Id The automatically generated primary key of the job_schdlr_cfg table. bigint
svc_host_name Service Host Name The name or IP address of the host machine. varchar(255)
svc_port Service Port TCPIP port. int
job_schdlr_instc_id Job Scheduler Instance Id An alternate automatically generated key of the job_schdlr_cfg table. varchar(255)
job_schdlr_dflt_interrupt Job Scheduler Default Interrupt Default for boolean to interrupt long running jobs. bit
job_schdlr_dflt_max_wait Job Scheduler default Maximum Wait Maximum wait time before interruption. bigint