This program allows you to read a record in the jobs table.
Parameters
NUM_BIN_4 |
Id |
Job ID.
|
ALPHA(50) |
Name |
(Output) Job name.
|
ALPHA(50) |
Type |
(Output) Job type (optional).
|
NUM_BIN_2 |
Unicity |
(Output) Unicity of execution in relation to type (value 0 or 1).
|
ALPHA(30) |
Profile |
(Output) User profile that submitted the job.
|
TIMESTAMP
|
CreationDate |
(Output) Job creation date. |
TIMESTAMP |
ActivationDate |
(Output) Job activation date.
|
TIMESTAMP |
StartDate |
(Output) Job start date.
|
TIMESTAMP |
EndDate |
(Output) Job end date.
|
ALPHA(250) |
Machine |
(Output) Machine on which the job must be run (optional).
|
NUM_BIN_4 |
QueueID |
(Output) Queue ID.
|
NUM_BIN_2 |
Priority |
(Output) Job priority, from 1 (high) to 5 (low).
|
ALPHA(1) |
FlagArchive |
(Output) Archiving mode: Possible values: " " do not archive, 'A' the report will be protected from deletion, 'D' the report will be deleted after the job has run. |
NUM_BIN_4 |
MaxExec |
Maximum run time before generating an alert. |
ALPHA(250) |
Program |
(Output) Program name (if the program adheres to the naming convention) or *SYSTEM, *CONSOLE for system commands.
|
ALPHA(1024) |
Parameter1 |
(Output) Parameter 1 of the program (if the program adheres to the naming convention) or system command line.
|
ALPHA(1024) |
Parameter2 |
(Output) Parameter 2 of the program (if the program adheres to the naming convention).
|
NUM_BIN_4 |
ReturnCode |
(Output) Program return code: 0 if the job has been read; SQL error code if not. |
