Monitoring Informatica Jobs

As Informatica tasks run as pre-scheduled or event-based jobs, you can monitor the jobs as you would any other type of job in TA using the Job Details dialog. You can also use Business Views to monitor job activity and view when the jobs are active.

To monitor job activity:

1. Choose Operations > Job Activity on the Navigator pane to display the Job Activity console.

2. Right-click job and click Details. The Status page appears by default. You can view the status of the job, the start and end time, how long it ran, and how it was scheduled. The External ID contains the workflow run id.

3. Click the Output tab to view the output for the PowerCenter job.

   The output consists of summary data for the workflow including all its tasks. If the Summary Only checkbox is selected for the job definition, no session log output is included. If the Summary Only checkbox is not selected, it includes the workflow log as well as any session logs for session tasks of the workflow.

4. Click the Informatica tab to view the job data for the run instance as defined during job definition. If the job is not currently running, you can override certain attributes of the definition prior to its scheduled run or rerun. Changes only affect the current instance of the job.

   When you override values, the new values are saved for this run instance only.

5. Click the Parameters tab to override parameters on the run instance.

6. Click the Job Status tab to override the Job Status determination.

7. Click the Advanced tab to override the job options.

8. Click the Concurrent tab to override the Concurrent Execution values.

9. Click the Run Info tab to view the runtime status of the workflow and its corresponding tasks. This tab provides data similar to what is shown in PowerCenter's Workflow Monitor.

   The Run Info tab contains these elements:

   • Workflow Summary

     Run ID – The workflow Run ID.

     Folder – The name of the folder containing the workflow.

     Workflow – The name of the scheduled workflow.

     Status – The status of the workflow.

     Start Time – The time the workflow began.

     Completion Time – The time the workflow completed.

   • Task Summary

     PID – The Parent ID for the task, either the Workflow Run ID or the Worklet Run ID, for worklet tasks.

     ID – The Run ID for worklet tasks (e.g. Worklet Run ID).

     Name – The name of the task.

     The indenting of the tasks allows for a graphical view of the parent child hierarchy for the tasks relative the their parent, which will be either the workflow itself or a worklet of the workflow.

   • Start Time – The time the task began.

   • Completion Time – The time the task completed.

   • Status – The status of the task.

   • Task Menu Options – There are several menu options that may initiated for a selected workflow task.

     Task Details – Click to display the Task Details dialog. This is the same as Task Details and is available once the task is completed. If the task is still running, this option is disabled.

     Restart From – Click to restart the workflow from the selected task. This is the same as Restart From and is available once the workflow is completed. If the workflow is still running, this option is disabled.

     Stop Task – Click to stop the selected workflow task running on the Integration Service. When you stop a task in the workflow, the Integration Service stops processing the task and all other tasks in its path. This option is available while the task is running. Once the task is no longer running, the option is disabled.

     Abort Task – Click to abort the selected, running workflow task. This option is available while the task is running. Once the task is no longer running, the option is disabled.

   • Buttons

     Refresh – Click to refresh the workflow status by re-requesting the workflow and task status from PowerCenter.

     Restart From – Click to restart the workflow from a selected task.

     Details – Click to view the workflow details by selecting Details or by double-clicking anywhere in the Workflow Run pane.

     The Workflow Details dialog appears run details for the workflow. You can double click any attribute to display an informational dialog containing the attributes full value.

     Example: You can double-click Log File Name to display the full long file name in an Information dialog. Click Log to display the Workflow Log dialog.

     By default, logs are retrieved given a request to the PowerCenter, but a direct read can be configured given job or connection options. Logs only apply to workflows and sessions and Log is only available for workflow and sessions.

     Click Save to save a copy of the logs to disk.

     Task Details – Given a selected task from the task details pane, you can view its details by clicking Task Details or by double-clicking a selected task.

     The Task Details dialog appears run details for the task. You can double-click any attribute to display an informational dialog containing the attribute's full value. For example, you can double-click Status Message to display the full status message in an Information dialog.

     For session tasks, click Log to display the Session Log dialog. Given a selected session task, you can also view the session log of completed sessions.

     Note: Log only applies to workflow and session tasks.

10. Click OK when you have completed viewing the job activity details to close the dialog.