Customizing the PeopleSoft Process Scheduler Shell JCL Template

All of the PeopleSoft Process Scheduler shell JCLs use meta-strings to pass data stored in the database or PeopleSoft Process Scheduler configuration files. PeopleSoft Process Scheduler uses meta-strings to generate the JCL based on one of these sources:

  • The profile of the user who initiated the request.

  • Parameters defined in the PeopleSoft Process Scheduler configuration file.

  • Parameters defined on the Process Type Definition page or the Process Definition page.

A good example of data that can be passed includes job account and job name. Enter the values of some of these variables by selecting PeopleTools, Security, Permissions & Roles, Permission Lists.

The shell JCL templates are tunable and should be changed according to your site-specific standards. The following table identifies the meta-strings that you can use in a shell JCL template.

If you create a new JCL template, be aware that:

  • The Shell ID is restricted to three characters.

  • The Shell ID is associated with the process type definition.

Meta-String

Description

%JOBNAME%

Specifies the value entered in the OS390 Job Controls Name field on the Process Profile Permission page for the permission lists specified as the user ID’s process profile. The process profile for a user ID can be set using the User Profiles page in the Security component.

%JOBACCT%

Specifies the value entered in the OS390 Job Controls Account field on the Process Profile Permission page.

%OUTDEST%

Specifies the output destination based on the value entered in the Server Destinations File or Printer field on the Process Profile Permission page.

%SFX%

Identifies a one-character code issued by PeopleSoft Process Scheduler. The system randomly assigns a value from A to Z.

%OPRID%

Identifies the user ID used to submit the request from PeopleSoft Process Scheduler.

%PRCSLOGFILE%

Identifies the name of the log file that PeopleSoft Process Scheduler used to redirect all data written to output for PeopleSoft Application Engine or SYSOUT in COBOL or SQR

%PRCSLOGDIR%

Identifies the directory to which all log files or reports are written in USS for a process.

%ACCESSID%

Identifies the access ID that is assigned for a user ID defined in PSOPRDEFN.

%INSTANCE%

Identifies the process instance number that is assigned to a process request.

%RUNID%

Identifies the run control ID used to submit the process request.

%OWNERID%

Identifies the owner ID for the PeopleSoft database.

%PRCSNAME%

Identifies the program name, as defined on the Process Definition page.

%DB2SUB%

Identifies the name of the DB2 subsystem specified in the DB2 Sub-System parameter in the OS390 section in the PeopleSoft Process Scheduler configuration file.

%PERFSTAT%

Sets the Performance Statistic option in the COBOL shell JCL. This is set to Y when the bit value of 128 is assigned to the TraceSQL parameter in the Trace section in the PeopleSoft Process Scheduler configuration file.

%DYNEXPLN%

Sets the Dynamic Explain option in the COBOL shell JCL. This is set to Y when the bit value of 256 is assigned to the TraceSQL parameter in the Trace section in the PeopleSoft Process Scheduler configuration file. Bit value 256 will also turn on Performance Statistics in the COBOL shell JCL (%PERFSTAT% will be set to Y) as is required to run the Dynamic Explain.

%PARALLEL%

Sets the Dynamic Explain option in the COBOL shell JCL. This is based on the Enable Parallel Processing parameter in the OS390 section in the PeopleSoft Process Scheduler configuration file.

"%TSOPLAN%

Indicates the DB2 plan name subsystem specified in the Plan name for PTPSQLRT with TSO parameter in the OS390 section in the PeopleSoft Process Scheduler configuration file.

%PSHLQ%

Indicates the high-level qualifier of the PeopleSoft dataset specified in the High Level Qualifier for Datasets parameter in the OS390 section of the PeopleSoft Process Scheduler configuration file.

%SQRINI%

Identifies the initialization file used by the SQR process. This meta-string is used exclusively for SQR.

Following is a sample job control card in one of the shell JCLs:

//%JOBNAME%%SFX% JOB %JOBACCT% > 'PS-PRCS ' > CLASS=E > MSGCLASS=X >

// NOTIFY=%OPRID%

If you do not use meta-strings, you can also update the job cards to remove these variables and replace them with actual values.

In the SHELL JCL for SQR, OUTNODE denotes either an OS390 partitioned dataset (PDS) or a sequential dataset. The PDS is a requirement for SQR output. If the SQR report XRFPANEL is directed to file output, the following substitution occurs:

In SHELSQRF.JCT, change// OUTNODE='%OUTDEST%' to // OUTNODE='HR.H800RAB' > .

If an SQR process is directed to print, the following substitutions occur:

// OUTNODE='DEST=U3' > OPTIONAL:USER-DEF OUTPUT . .

//*********************************************************************

//* Main portion of JCL Shell *

//*********************************************************************

..

//SQROUTP DD SYSOUT=* > DEST=U3

OS390 job controls specify the OS390 job name to assign to each process that is submitted. This value can be up to seven characters. Do not use lowercase letters or quotation marks. If you included the %SFX% meta-string as part of the job name, PeopleSoft Process Scheduler appends a one-character alphabetical suffix to this name (A through Z, chosen randomly) before the job submission.

For example, if you entered USRMVS1, the assigned job name becomes USRMVS1A through USRMVS1Z. After you enter the OS390 job name, enter the job account number that you used in the installation. Specify an account code to be inserted as the JCL accounting code.