| Workstation_name |
The name of the workstation or workstation class where the job was
defined. |
string |
16 |
| Job_definition_identifier |
The identifier of the job definition. |
character |
16 |
| Job_name |
The name of the job. |
string |
40 |
| Job_description |
A description of the job. |
string |
120 |
| Job_login_user |
The user name under which the job runs. |
string |
47 |
| Job_script_name |
The script or the command that the job runs. |
string |
- 4095
- In DB2®
- 4000
- In Oracle
|
| Job_folder_id |
The identifier of the folder that includes the job for which you want information
displayed. |
character |
16 |
| Job_folder_name |
The name of the folder containing the job for which you want information
displayed. |
string |
801 |
| Recovery_job_definition_id |
The identifier of the job definition to be run,
if the job specified in the job_definition_identifier column ends
abnormally. |
character |
16 |
| Recovery_job_name |
The name of the job to run if the job specified
in the Job_name column ends abnormally. |
string |
40 |
| Recovery_option |
The recovery options for the job. Possible values
are:
- C
- Continue
- R
- Rerun
- S
- Stop
|
character |
1 |
| Recovery_repeat_interval |
The interval in milliseconds after which a new execution of the job is launched
if the job failed |
integer |
12 |
| Recovery_repeat_occurrences |
The number of maximum attempts to launch the job if it failed |
integer |
5 |
| Recovery_repeat_affinity |
Specify whether the failed job must be rerun on the same workstation or the
target workstation must be selected by the broker. Supported values are:
- Y
- Yes: rerun on the same workstation.
- N
- No: the target workstation must be selected by the broker.
|
character |
1 |
| Recovery_prompt |
The text of the recovery prompt to display if the
job ends abnormally. |
string |
200 |
| Job_modify_user |
The name of the user who created or modified the
job definition. |
string |
50 |
| Successful_runs |
The number of times the job ran successfully. |
integer |
10 |
| Abended_runs |
The number of times the job ended abnormally. |
integer |
10 |
| Long_duration_runs |
The number of times the jobs with long duration
ran. |
integer |
10 |
| Suppressed_runs |
The number of jobs that have been suppressed, that
is the number of jobs whose until time has been reached, but the job
has not yet started. |
integer |
10 |
| Late_start_runs |
The number of times the jobs ended after the latest
start time was reached. |
integer |
10 |
| Late_end_runs |
The number of times the jobs ended after the deadline
was reached. |
integer |
10 |
| Total_reruns |
The total number of times the job reran. |
integer |
10 |
| Averarage_cpu_time |
The average amount of CPU time the job took to
run. This time is expressed in milliseconds. |
integer |
12 |
| Average_elapsed_time |
The average time the job took to run. This time
is expressed in milliseconds. |
integer |
12 |
| Total_elapsed_time |
The sum of the times the job used the CPU and the
time the job waited for other processes to release the CPU for all
its runs. This time is expressed in milliseconds. |
integer |
12 |
| Total_cpu_time |
The total amount of CPU time the job used to run,
for all its runs. This time is expressed in milliseconds. |
integer |
12 |
| Last_cpu_time |
Specifies how much CPU time the job used the last
time it ran. This time is expressed in milliseconds. |
integer |
12 |
| Last_elapsed_time |
The elapsed time recorded during the job last run
of the job. This time is expressed in milliseconds. |
integer |
12 |
| Last_run_date |
The date and time the job last ran. |
timestamp |
- 26
- In DB2®
- 35
- In Oracle
|
| Max_cpu_time |
The maximum CPU time recorded for all the job runs.
This time is expressed in milliseconds. |
integer |
12 |
| Max_elapsed_time |
The maximum elapsed time recorded for all its runs.
This time is expressed in milliseconds. |
integer |
12 |
| Max_run_date |
The date and time when the job took the longest
time to run. |
timestamp |
- 26
- In DB2®
- 35
- In Oracle
|
| Min_cpu_time |
The minimum CPU time recorded for all the runs.
This time is expressed in milliseconds. |
integer |
12 |
| Min_elapsed_time |
The minimum elapsed time recorded for all its runs. |
integer |
12 |
| Min_run_date |
The date and time when the job took the shortest
time to run. |
timestamp |
- 26
- In DB2®
- 35
- In Oracle
|
| Workstation_folder_id |
The identifier of the folder in which the workstation is defined. |
character |
16 |
| Workstation_folder_name |
The name of the folder in which the workstation is defined. |
string |
801 |
| Workstation_symphony_id |
An identifier used in the Symphony file to identify the workstation. |
string |
16 |