This table holds the run history for the JAS jobs and job runs.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| joid | decimal(15) | not null | The master job id. |
| run_num | integer | not null | The run number. Each job can be run multiple times. This number distinquishes those runs. |
| groupid | decimal(15) | with null | Strategy group. Composite key with ScheduledStartTime. |
| scheduledstarttime | decimal(15) | with null | Time_t timestamp. Composite key with GroupId. This is the time that the job was scheduled to start - not the actual start time. This is not adjusted for the time zone. It is used along with GroupId to review the status of a specific run of a strategy group's jobs. The value come from Job.Next_Start. Since this is not adjusted for the time zone, it will be constant from machine to machine for the strategy. If it were time zone adjusted, this value could potentially be shifted for the time zone of node where the machine is and thus the jobs will all have different GMT times. |
| timezone | varchar(12) | with null | Time zone the job ran in. |
| starttime | decimal(15) | with null | Time_t timestamp. Date and time started. If =0, the job never ran. This is set to the current time just before the job is forked. |
| endtime | decimal(15) | with null | Time_t timestamp. Date and time completed |
| startstatus | smallint | with null | Status of how the job started - set by the scheduler. Any status other than 0 means the job never started. 0 = Job started successfully 1 = Job never ran because the start time passed while the scheduler was down and the job was not recurring. Job expired (time to run has passed) 2 = Could not execute (O/S status in JobHist.Status) 3 = Fork failed (O/S status in JobHist.Status) 4 = Invalid User If user != NULL (O/S status in JobHist.Status) |
| osstatus | decimal(15) | with null | Status of the process creation returned by the operating system. |
| failed | smallint | with null | Set by the scheduler. If 0, the job was successful. Otherwise, if failed. This is set on if the job failed for any reason: preempted, OS failure, or point product failure. |
| preempted | smallint | with null | This indicates that the job did not run because the point product determined that it should not run due to poinr product specific operating rules. |
| stopped | smallint | with null | Job process finished without notifying agent. Status is not known and the failure flag cannot be relied upon. The scheduler periodically checks the jobs it started using "SigUsr2". If the process is no longer, this will be set to true. |
| status | integer | with null | If StartStatus = 0, this is the completion status code assigned by point product. If the job never started (StartStatus > 0), this field is set by the scheduler. |
| logfilename | varchar(255) | with null | Name of the log file for the job. |
Product Name: Unicenter Database Management
Table Type: Table