jpqendjobshow
- Organization of this page
Format
jpqendjobshow [-mh manager-host-name] [-u owner-name] [-sa time] [-sp time] [-rn output-job-information-count] [-qn]
Description
Outputs a list of ended job information (including the job number and submittal destination queue name) to the standard output.
You can also output ended job information about the JP1/NQSEXEC and JP1/OJE for VOS3 hosts.
You can also output ended job information about the AS/400 system.
This command is applicable for the following jobs:
- When the database is in a standard configuration:
-
Submit jobs and queue jobs
- When the database is in a standard configuration without ISAM:
-
None
- When the database is in a compatible ISAM configuration:
-
PC jobs (other than queueless jobs), UNIX jobs (other than queueless jobs), action jobs, custom jobs, submit jobs, and queue jobs
Execution privileges
You must have any of the following JP1 privileges:
-
JP1_JPQ_Admin privilege
-
JP1_JPQ_Operator privilege
-
JP1_JPQ_User privilege (allows you to manipulate only the jobs you own)
Arguments
-mh manager-host-name
Specify the name of the manager host to which you have submitted a job whose job information is to be output.
You can specify a character string of 1 to 255 bytes.
By default, the system assumes the local host name.
-u owner-name
Specify the job owner name.
You can specify a character string of 1 to 63 bytes. By default, the system assumes all the users if a user having the JP1_JPQ_Admin privilege or JP1_JPQ_Operator privilege executes the command. If a user having the JP1_JPQ_User privilege executes the command, the system assumes that user.
-sa time
If you want to output information about jobs whose execution ended after a specific time, specify the time based on the time of the host on which the command is executed. The format of the time you specify is YYYY/MM/DD.hh:mm:ss. You can specify a time between 1980/01/01.00:00:00 and 2038/01/18.03:14:07. By default, the system assumes the time for the oldest job information.
-
YYYY
Specify a year. You can specify 1980 to 2038.
-
MM
Specify a month. You can specify 01 to 12.
-
DD
Specify a day. You can specify 01 to 31.
-
hh
Specify hours. You can specify 00 to 23.
-
mm
Specify minutes. You can specify 00 to 59.
-
ss
Specify seconds. You can specify 00 to 59.
-sp time
If you want to output information about jobs whose execution ended before a specific time, specify the time based on the local time of the host on which the command is executed. The format of the time you specify is YYYY/MM/DD.hh:mm:ss. You can specify a time between 1980/01/01.00:00:00 and 2038/01/18.03:14:07. By default, the system assumes the time for the oldest job information.
-
YYYY
Specify a year. You can specify 1980 to 2038.
-
MM
Specify a month. You can specify 01 to 12.
-
DD
Specify a day. You can specify 01 to 31.
-
hh
Specify hours. You can specify 00 to 23.
-
mm
Specify minutes. You can specify 00 to 59.
-
ss
Specify seconds. You can specify 00 to 59.
-rn output-job-information-count
Specify the number of pieces of job information to be output. (The system outputs the number of pieces of job information specified with this option, among the end job information in the range specified with the -sa and -sp options, starting from information about the job for which the end time is the latest.)
You can specify a value between 0 and 4,294,967,295. If you omit this option, the system assumes 0.
If you set 0, the system outputs all the job information in the manager host set by the -mh option.
-qn
Outputs the job number, and queue type, and name as job information.
Note
The number of bytes which can be output is fixed for each output item. If the contents of an output item exceed the output limit, they end with "..". (For example, the job name output limit is 26 bytes. If the job name exceeds 26 bytes, the 25th and subsequent bytes become "..".) For the queue name that can be output by the -qn option, all the contents are output.
To output all the contents on each output item, use the jpqjobget command.
Return values
0 |
Normal end |
1 |
Invalid parameter value |
2 |
An attempt to output information about ended jobs failed due to an internal cause of the host on which the jpqendjobshow command was executed. |
5 |
Initialization has failed.
|
6 |
Memory became insufficient on the host on which the jpqendjobshow command was executed. |
7 |
A logical error occurred on the host on which the jpqendjobshow command was executed. |
100 |
The host on which the jpqendjobshow command was executed cannot connect to the manager host via TCP/IP communication.
|
102 |
The IP address could not be resolved from the name of the manager host on which the jpqendjobshow command was executed. |
200 |
The manager host does not accept ended job information output.
|
202 |
The manager host has returned no response. |
203 |
Ended job information could not be output successfully owing to an internal cause of the manager host. |
206 |
You do not have the privilege required to output ended job information. |
207 |
The specified job is not found.
|
219 |
The manager host is busy. |
222 |
A fatal error has occurred.
|
223 |
The manager host encountered a logic error. |
224 |
You have issued an end job information output request to an unsupported host. |
226 |
Invalid execution environment |
Output example 1
The following gives an example of file output when you specify the -qn option, and describes the meanings of output contents.
The following gives the meanings of output contents.
- JOBID
-
Indicates a job number.
- T
-
Indicates a queue type.
-
q: Queue
-
a: Agent host
-
- QUEUE
-
Indicates a queue name (or an agent host name).
Output example 2
The following gives an example of file output when you do not specify the -qn option, and describes the meanings of output contents.
The following shows the meaning of the output.
- JOBID
-
Indicates a job number.
- JOBNAME
-
Indicates a job name.
26 bytes of data are output.
When you use a QUEUE job or the jpqjobsub command to specify a job name, that job name is set. If no job name is specified, the execution file name is set.
When you define a PC job in a jobnet, the execution file name is set. When you define a Unix job in a jobnet, the script file name is set. If you do not specify a script file name, and then define a job name in a command statement, script_job is set as the job name.
For an action job, the name of the fixed execution file executed by each action job is set as the job name. For an execution file name, the first 63 bytes of the characters from the beginning of the file name, excluding the path information, are set as the job name, and the first 26 bytes are displayed.
- T
-
Indicates a queue type.
-
q: Queue
-
a: Agent host
-
- QUEUE
-
Indicates a queue name (or an agent host name).
27 bytes of data are output.
- EXITCODE
-
Indicates a return code (including symbols).