Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ComputerID | INT | 10 | null |
|
|
|||
| JobID | VARCHAR | 200 | null |
|
|
|||
| Status | INT | 10 | null |
|
|
|||
| NextRunTime | DATETIME | 19 | null |
|
|
|||
| Source | VARCHAR | 255 | null |
|
|
|||
| Destination | VARCHAR | 255 | null |
|
|
|||
| Image | VARCHAR | 255 | null |
|
|
|||
| Compression | VARCHAR | 255 | null |
|
|
|||
| Encryption | VARCHAR | 255 | null |
|
|
|||
| Options | VARCHAR | 255 | null |
|
|
|||
| ScheduleBase | VARCHAR | 2000 | null |
|
|
|||
| Excluders | VARCHAR | 2000 | null |
|
|
|||
| TotalTime | VARCHAR | 255 | null |
|
|
|||
| TaskID | VARCHAR | 255 | null |
|
|
|||
| TaskLog | TEXT | 65535 | null |
|
|
|||
| LastStatus | INT | 10 | null |
|
|
|||
| MaxImageSize | INT | 10 | null |
|
|
|||
| IOThrottle | INT | 10 | null |
|
|
|||
| PreSnapshot | VARCHAR | 255 | null |
|
|
|||
| PostSnapshot | VARCHAR | 255 | null |
|
|
|||
| PostBackup | VARCHAR | 255 | null |
|
|
|||
| CommandTimeout | INT | 10 | null |
|
|
|||
| RetentionPolicy | INT | 10 | null |
|
|
|||
| ImagesToRetain | INT | 10 | null |
|
|
|||
| Comments | VARCHAR | 1000 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ComputerID | Performance | Asc | ComputerID |
| JobID | Performance | Asc | JobID |
| NextRunTime | Performance | Asc | NextRunTime |
| Status | Performance | Asc | Status |
Diagram producer might be missing
No diagrams were produced please see application output for any errors