HCL Workload Automation, Version 9.4

jbxtract

Extracts information about jobs from the database.

Syntax

jbxtract [-V | -U]
     [-j job]
     [-c wkstat]
     [-o output]

Arguments

-V
Displays the command version and exits.
-U
Displays command usage information and exits.
-j job
Specifies the job for which extraction is performed. The default is all jobs.
-c wkstat
Specifies the workstation of jobs for which extraction is performed. The default is all workstations.
-o output
Specifies the output file. The default is stdout.

Results

The MAESTRO_OUTPUT_STYLE variable specifies the output style for long object names. With value LONG, full length (long) fields are used for object names. If the variable is set to anything other than LONG, long names are truncated to eight characters and a plus sign. For example: A1234567+.

Each job record contains tab-delimited, variable length fields. The fields are described Table 1.
Table 1. Jbxtract output fields
Field Description Max Length (bytes)
1 workstation name 16
2 job name 16
3 job script file name 4096
4 job description 65
5 recovery job name 16
6 recovery option (0=stop, 1=rerun, 2=continue) 5
7 recovery prompt text 64
8 auto-documentation flag (0=disabled, 1=enabled) 5
9 job login user name 36
10 job creator user name 36
11 number of successful runs 5
12 number of abended runs 5
13 total elapsed time of all job runs 8
14 total cpu time of all job runs 8
15 average elapsed time 8
16 last run date (yymmdd) 8
17 last run time (hhmm) 8
18 last cpu seconds 8
19 last elapsed time 8
20 maximum cpu seconds 8
21 maximum elapsed time 8
22 maximum run date (yymmdd) 8
23 minimum cpu seconds 8
24 minimum elapsed time 8
25 minimum run date (yymmdd) 8
Note: The elapsed time displayed for a shadow job is the elapsed time of the remote job to which it is bound.

Examples

To extract information about job myjob on workstation main and direct the output to the file jinfo, run the following command:
jbxtract -j myjob -c main -o jinfo