The HSURDJOB table is used for scheduled client jobs and is populated during the Client – Work with Jobs phase. The following table describes the columns in the HSURDJOB table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| JOBRECID | BINARY | 9 | 0 | job ID |
| USERID | CHARACTER | 10 | 0 | user ID |
| JOBNAME | CHARACTER | 10 | 0 | job name |
| JOBPARM | CHARACTER | 1024 | 0 | job parameter |
| FLSTATUS | CHARACTER | 1 | 0 | flag status |
| DTTMSUBM | CHARACTER | 16 | 0 | scheduled timestamp |
| DTTMSTART | CHARACTER | 16 | 0 | submitted timestamp |
| DTTMEND | CHARACTER | 16 | 0 | ended timestamp |