| Parameter | Reference | Type | Length | Default | Optional | Text |
|---|---|---|---|---|---|---|
| COMMAND | MSQJOBSTEP-JOBCOMMAND | C | 520 | |||
| CON_NAME | DBCON-CON_NAME | C | 30 | 'DEFAULT' | X | Logical name for a database connection |
| DBNAME | MSSDB | C | 128 | Database name | ||
| DESCRIPTION | MSQSYSJOBS-JOBDESC | C | 255 | |||
| ENABLED | MSQSYSJOBS-ENABLED | s | 2 | |||
| FREQINT | MSQIMPORT-FREQINT | I | 4 | 1 | X | |
| FREQTYPE | MSQIMPORT-FREQTYP | I | 4 | 1 | X | |
| FREQUNITINT | MSQIMPORT-FREQTYP | I | 4 | |||
| FREQUNITTYPE | MSQIMPORT-FREQTYP | I | 4 | |||
| OWNER | MSSUNAME | C | 30 | X | MS SQL Server user name | |
| SCHEMA | MSSSCHEMA | C | 128 | '' | X | Schema name |
| STARTDATE | MSQIMPORT-JOBDATE | I | 4 | |||
| STARTTIME | MSQIMPORT-JOBTIME | I | 4 | |||
| STEPID | MSQJOBSTEP-STEPID | I | 4 | |||
| STEPNAME | MSQJOBSTEP-STEPNAME | C | 100 | 'STEP1' | X | |
| SUBSYSTEM | MSQJOBSTEP-SUBSYSTEM | C | 60 | 'TSQL' | X | |
| TASKNAME | MSQSYSJOBS-JOBNAME | C | 100 |
| Parameter | Reference | Type | Length | Text |
|---|---|---|---|---|
| R_JOBID | MSQSYSJOBS-JOBID | X | 16 | MS SQL server - error number of the last executed sql stmt |
| Exception | Text |
|---|---|
| CONNECT_ERROR | |
| DB_ERROR | |
| INTERNAL_ERROR | |
| NOT_RUNNING_ON_MSSQL |