Attribute Name |
Attribute Definition |
Logical Datatype |
Is Required |
Job Configuration Detail Id |
The automatically generated primary key of the job_cfg_dtl table. |
LONG |
Yes |
Job Scheduler Configuration Id |
A Foreign Key to the Job Scheduler Configuration table. |
LONG |
Yes |
Job Name |
The name of the job |
VARCHAR(100) |
No |
Job Class |
The java class name of the job |
VARCHAR(150) |
No |
Group Name |
Used for time based rules grouping. |
VARCHAR(100) |
No |
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) |
No |
Trigger Start Date |
The start date of scheduled running. Not required |
DATE |
No |
Trigger End Date |
Trigger End Date. |
DATE |
No |
Trigger Hour |
The Hours portion of a time of day |
INTEGER |
No |
Trigger Minute |
The minutes portion of a time of day |
INTEGER |
No |
Trigger Frequency |
Numeric frequency. e.g 15 in Minutely 15
|
INTEGER |
No |
Is Job Enabled |
False if disabled. |
BOOLEAN |
No |
History Retain Days |
Days to retain history of jobs before cleanup |
INTEGER |
No |
History Retain Count |
Number of executions before cleanup. |
INTEGER |
No |
Job Parameters |
Array of parameters used to pass to job. |
TEXT |
No |
Create Date |
The date that the Job Configuration Detail was created. |
DATE |
No |
Create User |
User that created job |
VARCHAR(255) |
No |
Cron |
For trigger type CRON JOB, the cron job arguments that will be passed on the command line. |
VARCHAR(255) |
No |
Repeat Count |
0 if not used. Can be set to a finite number.
|
INTEGER |
No |
Time Zone |
The value of a Job Configuration Detail, stored as a string. |
VARCHAR(255) |
No |
Version ID |
A Foreign Key to the Job Configuration Detail table. |
LONG |
No |