JobStatus (ver2.3)
This table stores information regarding jobs scheduled using quartz.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ComponentName | 2.3 | Varchar2(30) | ComponentName from the associated ApplicationComponent record. |
EndTs | 2.3 | Timestamp | Time the job finishes running. |
ID | 2.3 | Number(19,0) | Unique sequential number generated by the application. Required. |
JobGroup | 2.3 | Varchar2(200) | Job_Group of the associated Qrtz_Job_Details record. Used to identify the job by the quartz scheduler. |
JobName | 2.3 | Varchar2(200) | Job_Name of the associated Qrtz_Job_Details record. Used to identify the job by the quartz scheduler. |
JobType | 2.3 | Varchar2(30) | Used to segregate jobs into groups. Ex. Email. Required. |
ScheduledTs | 2.3 | Timestamp | Time the job is scheduled to run. |
StartTs | 2.3 | Timestamp | Time the job starts running. |
Status | 2.3 | Number(3,0) | Valid values:
|
WhenCreated | 2.3 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 2.3 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 2.3 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 2.3 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |