Subject Area : 120 - Job Scheduler
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 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. Details.. Details..
ER Diagram(s) of Subject Area "120 - Job Scheduler"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "120 - Job Scheduler"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 2
. job_cfg_dtl Job Configuration Detail false The job configuration details that will be used to create jobs on the job scheduler. Details..
. 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. Details..
Attribute/Column(s) of Entity/Table "Job Configuration Detail"
# Physical Name Name Definition Physical Data Type
Total 21
. 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
Attribute/Column(s) of Entity/Table "Job Scheduler Configuration"
# Physical Name Name Definition Physical Data Type
Total 6
. 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