Working with Workload Objects › PeopleSoft Jobs › Define a PeopleSoft Job to Run a Request

Define a PeopleSoft Job to Run a Request

You can define a PeopleSoft job to schedule workload to run in PeopleSoft. The job runs a PeopleSoft request or a collection of requests.

Note: To run these jobs, your system requires CA WA Agent for UNIX, Linux, or Windows and CA WA Agent for PeopleSoft.

Do not use the following special characters when defining PeopleSoft jobs: left parenthesis ( ( ) and right parenthesis ( ) ) and apostrophe ('). Use caution when using other special characters, such as backslash (\) and at (@).

Follow these steps:

1. Open the Application that you want to add the job to in the Define perspective.

   The Application appears in the workspace.

2. Select the PeopleSoft job from the Palette view, and drag the job to the workspace.

   The PeopleSoft icon appears on the Application workspace view.

3. Right-click the PeopleSoft icon, and select Edit from the pop-up menu.

   The Basic page of the PeopleSoft dialog opens.

4. Complete the following required fields:

   Name

   Defines the name of the job that you want to schedule.

   Limits: 128 alphanumeric characters, plus the special characters commercial at (@), pound (#), dollar sign ($), underscore (_), square brackets ([]), brace brackets ({}), and percent sign (%) as a symbolic variable introducer character.

   Agent name

   Specifies the name of the agent that runs the PeopleSoft request.

   Process name

   Specifies the name of the PeopleSoft process you want the job to run. PeopleSoft stores the list of process names in the PS_PRCSDEFN table.

   Example: AEMINITEST

   Process type

   Specifies the PeopleSoft process type corresponding to the process that you want to run. PeopleSoft stores the list of process types in the PS_PRCSTYPEDEFN table. This value corresponds to the Process Type field in PeopleSoft.

   Example: Application Engine

   Note: If the process type corresponding to the process that you want to run does not appear in the drop-down list, you can type the process type in the field.

5. Click Other PS Parameters in the left pane to enter the required PS operator ID and run control ID.

   The Other PS Parameters page opens in the right pane.

6. Complete the following required information, as appropriate:

   PS operator ID

   Specifies the PeopleSoft operator ID under whose authority the report runs. The operator ID must be defined as a user in the Topology. This field supports the use of a namespace for a user that has more than one password. Contact your administrator for the user name defined in the Topology.

   Note: This field is mandatory unless its value is specified in the agent parameter (agentparm.txt) file. The value you enter in the job definition overrides the default value in the agentparm.txt file.

   Example: Bob, Production:Bob

   Run control ID

   Identifies a set of PeopleSoft run parameters for a given PeopleSoft process.

   Example: FLOOR8_COLOR

   Note: This field is mandatory unless its value is specified in the agent parameter (agentparm.txt) file. The value you enter in the job definition overrides the default value in the agentparm.txt file.

7. (Optional) Specify the following additional information:

   Server name

   (Optional) Specifies the name of the target server executing the PeopleSoft job. PeopleSoft stores the list of server names in the PS_SERVERDEFN table.

   Example: PSNT

   Output destination type

   (Optional) Specifies the type of output for the report: NONE, FILE, PRINTER, EMAIL, or WEB.

   Note: If you select EMAIL or WEB as the Output destination type, you can distribute the PeopleSoft report electronically to operators, groups of people, or individuals. Use the Distribution page to specify your distribution.

   Example: WEB

   Output destination format

   (Optional) Specifies the type of format for the report output. PeopleSoft stores the list of output destination formats in the PSXLATITEM table.

   Example: CSV

   Output destination path

   (Optional) Defines the path to the output directory. Enter a path to change the output location for FILE and PRINTER output destination types. The path you define in this field overrides the default path defined by the PeopleSoft system.

   Example: \\CYBERMATION\Q-SUPPORT

   Time zone

   (Optional) Specifies a different time zone for the report being run.

   Example: Central Time (US)

   Arguments

   (Optional) Defines an argument string of positional parameters to be appended to the PeopleSoft database. Additional arguments that are specified in this field are appended in a parameter list.

   Most parameters for a particular PeopleSoft job are specified in a parameter list in two database tables:

   • PS_PRCSTYPEDEFN-Template for a process type
   • PS_PRCSDEFN-Additional parameters for a particular process name

   Example: -ORIENTL "SHARE"

   Skip parameter updates

   (Optional) Indicates whether you want the Agent to update job parameters with data in the PS_PRCSDEFN table. If you select Yes, the Agent does not update the parameters in the table.

   Note: We recommend you skip parameter updates when some bind variables in the table PS_PRCSDEFN may not be suitably defined. You can use the Arguments field to pass additional argument values.

   Disable restart

   (Optional) Indicates whether to disable a restart feature for previously failed jobs from the point where the job failed. By default, when a previously-failed job is resubmitted, it will restart from where it was stopped.

8. (Optional) Click Run Control Table List in the left pane to modify run control parameters.

   The Run Control Table List page opens in the right pane.

9. Click Add.

   A new row is added to the Run control table list table.

10. Complete the following fields as required:

    Run control table name

    (Optional) Specifies the table name that contains the run parameters for a given PeopleSoft process.

    Example: PS_AEREQUESTTBL

    Run control arguments

    (Optional) Specifies the run parameters for a PeopleSoft process. Enter a list of argument values separated by commas. You can include symbolic variables in your argument string.

    Note: You must surround arguments containing special characters with double quotation marks.

11. (Optional) Repeat the previous two steps to specify run control parameters in additional run control tables.
12. Click OK.

    The PeopleSoft job is defined.

Example: Add a Row of Process Parameters to a Run Control Table

Suppose you have a PeopleSoft run control table named PS_AEREQUESTTBL that contains the following columns. You want to have the following run control data. The agent that runs the PeopleSoft job you define is named PSAGENT. The process name you want the job to run is called XYZ and its process type is Application Engine.

To add a row of process parameters to a run control table

1. Enter the following required information in the Basic page:
   • Agent name—PSAGENT
   • Process name—XYZ
   • Process type—Application Engine
2. Enter the following required information in the Other PS Parameters page:
   • PS operator ID—VP1
   • Run control ID—test
3. Open the Run Control Table List page.
4. Click Add and enter the following information in the first row of the table:
   • Run control table—PS_AEREQUESTTBL
   • Run control arguments—BI_WF_0001,0,O,N,0,N,,b\”,sysdate
5. Click OK.

This request adds the new row of values to the PS_AEREQUESTTBL run control table.

More information:

PeopleSoft Jobs

Distribute PeopleSoft Reports

Using a Namespace for a User that has Different Passwords