AUTOSTART_JOB_INFO view

The AUTOSTART_JOB_INFO view returns information about autostart jobs.

The values returned for the columns in the view are closely related to the values returned by the Display Autostart Job Entries panel accessed through the DSPSBSD (Display Subsystem Description) CL command and by the List Subsystem Entries (QWDLSBSE) API.

Authorization: The caller must have:

*EXECUTE authority to the library containing the subsystem description, and
*USE authority to the subsystem description.

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

Table 1. AUTOSTART_JOB_INFO view
Column Name	System Column Name	Data Type	Description
SUBSYSTEM_DESCRIPTION_LIBRARY	SBSD_LIB	VARCHAR(10)	The name of the library in which the subsystem description resides.
SUBSYSTEM_DESCRIPTION	SBSD	VARCHAR(10)	The name of the subsystem about which information is being returned.
AUTOSTART_JOB_NAME	AJ_NAME	VARCHAR(10)	The simple name of the job that is automatically started when the associated subsystem is started.
JOB_DESCRIPTION_LIBRARY	JOBDLIB	VARCHAR(10)	The name of the library in which the job description for the autostart job entry resides.
JOB_DESCRIPTION	JOBD	VARCHAR(10)	The name of the job description for the autostart job entry.

Example

List all the autostart job entries in the QUSRWRK subsystem.

SELECT AUTOSTART_JOB_NAME, JOB_DESCRIPTION_LIBRARY, JOB_DESCRIPTION
  FROM QSYS2.AUTOSTART_JOB_INFO 
  WHERE SUBSYSTEM_DESCRIPTION_LIBRARY = 'QSYS' AND 
        SUBSYSTEM_DESCRIPTION = 'QSYSWRK'
  ORDER BY 1, 2, 3;