Manually Creating RA Informatica Agent Session, Task, or Worklet Jobs

Define Jobs that run Informatica Tasks, Sessions, or Worklets by creating SESSIONORTASKJOB Job types and using the Informatica tab in a Job definition.

To create an RA Informatica Agent Task, Session, or Worklet Job:

  1. Add a new Job by picking Informatica as your Job type and selecting SESSIONORTASKJOB.
  2. From the Job definition, select your RA Informatica Agent solution Agent object.
  3. Go to the Informatica tab and enter the following information:
    • Connection to Repository

      • The Connection object you created. Make sure you select a Connection object that can connect to the Agent you selected for the Job.

    • Folder Name

      • The Informatica folder that contains the Workflow. This field is inactive until you select a connection to repository.

    • Workflow Name

      • The Workflow assigned to the Task, Session, or Worklet. This field is inactive until you select a folder name.

    • Task or Session Name

      • The Task, Session, or Worklet you wish to run. This field allows you to select Tasks, Sessions, and Worklets from inside non-reusable Worklets.

      For a non-reusable Worklets, this list includes all:

      • Of the Worklet's Tasks, Sessions, reusable Worklets, and non-reusable Worklets.
      • Tasks, Sessions, and Worklets belonging to non-reusable Worklets.

      When Tasks, Sessions, and Worklets are included in non-reusable Worklets, they will be listed in this list with their Worklet name followed by a period, and their name. When non-reusable Worklets include nested non-reusable Worklets, each non-reusable Worklet is listed separated by a period.

    • Parameter File Name

      • An optional Informatica parameter file.

    • Run Instance Name

      • An optional field to specify a string to pass to the Informatica PowerCenter Monitor. If the replacement value {JOB_RUNID} is used, the run ID will be used as part of the string. When this field is empty, the Automation Engine Run ID will be used.

      That only applies when the session was created concurrent in PowerCenter.

    • Abort on kill

      • When checked, the Job will abort when a kill command is issued from the Automation Engine. When unchecked (default), the Job is stopped.

  4. Add/edit Job parameters.
    5. To: Do this:

    Use a parameter file.

    Enter the parameter file name in the Parameter File Name field. When a parameter file is used, the parameters in the Job Parameters table are ignored.

    Get and set values for parameters already defined in Informatica.

    Leave the Parameter File Name blank, go to the Job Parameters page and click Get Parameters, the RA Informatica Agent adds the parameters defined in Informatica to the table. You can edit the parameter values by editing the Value column.

    Default values will be used for parameters that are already defined in Informatica, but they will not be displayed in the Value column.

    Add a custom parameter to the Job Parameters table.

    Click Add, the RA Informatica Agent adds a row where you can specify the name and value.

    Edit a custom parameter from the Job Parameters table.

    Edit the Value column.

    Delete a custom parameter from the Job Parameters table.

    Select a row and click Delete.

Killing Failed Session or Task Jobs

If a SESSIONORTASKJOB Job type task fails in Informatica, and you issue a Cancel command on it from Automation Engine or a Kill command on it from Applications Manager; the RA Informatica Agent will kill the Session or Task's parent Workflow. This is done, because these Workflows only have one Session or Task in them. This way, the Workflow status will match the status of its only child.