Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Duration | Unknown | 0 | null |
|
|
Execution duration - Time taken to complete the job |
||
| ErrorMessage | Unknown | 0 | null |
|
|
Error details - Error message if job execution failed |
||
| ExecutionDate | Unknown | 0 | null |
|
|
Execution timestamp - When the job was executed |
||
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each job execution record |
|
| FieldID | int | 4 | √ | null |
|
|
Field identifier - Reference to specific field affected by the job |
|
| TableName | varchar | 50 | √ | null |
|
|
Target table - Database table affected by the job |
|
| FieldName | varchar | 50 | √ | null |
|
|
Field name - Name of the field that was modified by the job |
|
| RecordsProcessed | Unknown | 0 | null |
|
|
Records processed - Number of records processed by the job |
||
| Status | Unknown | 0 | null |
|
|
Execution status - Status of job execution (Success, Failed, Warning) |
||
| ValueBefore | varchar | 4000 | √ | null |
|
|
Value before - Value of the field before job execution |
|
| ValueAfter | varchar | 4000 | √ | null |
|
|
Value after - Value of the field after job execution |
|
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When the job history record was created |
|
| JobName | varchar | 200 | √ | null |
|
|
Job name - Name of the scheduled job that was executed |
|
| CompanyID | int | 4 | √ | null |
|
|
Company reference - Reference to company for multi-tenant job execution tracking |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__NightlyJ__3214EC2728B808A7 | Primary key | Asc | ID |