TRACKED_JOB_QUEUES view

The TRACKED_JOB_QUEUES view returns a list of job queues that have been registered to be tracked.

Job queues can be added or removed from tracking using the ADD_TRACKED_JOB_QUEUE and REMOVE_TRACKED_JOB_QUEUE procedures.

Authorization: The caller must have *JOBCTL special authority.

The following table describes the columns in the view. The system name is TRACKED_JQ. The schema is QSYS2.

Table 1. TRACKED_JOB_QUEUES view
Column Name	System Column Name	Data Type	Description
IASP_NAME	JOBQ_IASP	VARCHAR(10)	The name of the auxiliary storage pool (ASP) device where the job queue resides. Can contain the following special value: *SYSBAS The job queue resides in the system ASP (ASP 1) or one of the defined basic user ASPs (ASPs 2-32).
JOB_QUEUE_LIBRARY	JOBQ_LIB	VARCHAR(10)	The library that contains JOB_QUEUE_NAME.
JOB_QUEUE	JOBQ	VARCHAR(10)	The name of the job queue that is being tracked.
JOB_RETENTION_PERIOD	RET_PERIOD	INTEGER	The number of minutes job tracking information will be retained in the tracking file after the job has ended.
TRACKING_FILE_IASP	TRACK_IASP	VARCHAR(10)	The name of the IASP device where the job tracking file is created.

Example

Review all job queues being tracked:

SELECT *
  FROM QSYS2.TRACKED_JOB_QUEUES
  ORDER BY IASP_NAME, JOB_QUEUE_LIBRARY, JOB_QUEUE;