|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Backend Scheduling Sub Tasks
Table Name: BSJ1
Table Description: Backend Scheduling Sub Tasks
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ID | Job ID | Int | 11 | OBSJ | Â | Â | Â |
| TaskID | Sub Task ID | Int | 11 | - | Â | Â | Â |
| Type | Task Type | nVarChar | 50 | - | Â | Â | Â |
| Params | Parameters | Text | 16 | - | Â | Â | Â |
| RunAs | Run As User | Int | 6 | OUSR | Â | Â | Â |
| Status | Status | VarChar | 1 | - | S | S | Scheduled |
| Â | Â | Â | Â | Â | Â | R | Running |
| Â | Â | Â | Â | Â | Â | E | Error |
| Â | Â | Â | Â | Â | Â | F | Finished |
| Â | Â | Â | Â | Â | Â | P | Pending |
| Â | Â | Â | Â | Â | Â | C | Creating |
| PostTask | Post-Task | Int | 11 | - | Â | Â | Â |
| PreTask | Pre-Task | Int | 11 | - | Â | Â | Â |
| LastDate | Last Running Date | Date | 8 | - | Â | Â | Â |
| LastTime | Last Running Time | Int | 6 | - | Â | Â | Â |
| Duration | Duration | Num | 19.6 | - | Â | Â | Â |
| Retry | Retry Times | Int | 11 | - | 0 | Â | Â |
| TimeOut | Time out | Int | 11 | - | 20 | Â | Â |
| Message | Status Message | nVarChar | 200 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | ID |
| Â | Â | TaskID |