Start of change

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:
  • *USE authority to the subsystem description, and
  • *EXECUTE authority to the library containing 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;
End of change