Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AutomatedJobID | int identity | 4 | √ | null |
|
|
Primary key - AutomatedJob unique identifier for each record |
|
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this job is currently enabled for execution |
||
| JobDescription | Unknown | 0 | null |
|
|
Job description - Detailed description of what the job does |
||
| JobID | Unknown | 0 | null |
|
|
Primary key - AutomatedJob unique identifier for each automated job |
||
| JobName | varchar | 100 | null |
|
|
Job name - Descriptive name of the automated job |
||
| CompanyID | int | 4 | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||
| Description | varchar | 2147483647 | √ | null |
|
|
Description field - Detailed description or explanation of AutomatedJob information |
|
| DateCreated | datetime | 16,3 | null |
|
|
Date/time field - Date and time when created occurred or was recorded |
||
| JobType | Unknown | 0 | null |
|
|
Job type - Classification of the job (Billing, Maintenance, Report, etc.) |
||
| LastRunDate | Unknown | 0 | null |
|
|
Last run date - Date and time when this job was last executed |
||
| NextRunDate | Unknown | 0 | null |
|
|
Next run date - Date and time when this job is scheduled to run next |
||
| SchedulePattern | Unknown | 0 | null |
|
|
Schedule pattern - Cron expression or schedule pattern for job execution |
||
| Status | int | 4 | null |
|
|
Status indicator - Current operational status or state of AutomatedJob records |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AutomatedJob | Primary key | Asc | AutomatedJobID |