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
|