Controlling Informatica PowerCenter Tasks and Workflows

The Scheduler provides these job control capabilities for the current process or the entire job:

  • Holding/Stopping a Job

  • Releasing/Resuming a Job

  • Cancelling/Aborting a Job

  • Rerunning a Job

  • Making One-time Changes to an Adapter Job Instance

Holding/Stopping a Job

Note: This functionality is only available for workflows, including those started from a step.

Note: If you start a job containing multiple steps of the "Run Task Only" type and issue a Stop or Hold action during its execution, the step where the stop was triggered will complete. However, the subsequent steps will not execute. The job will then terminate with a status of either "Completed Normally" or "Completed Abnormally" depending on the result of the step that was completed.

Adapter jobs are held only before they are launched. Once a job reaches the Adapter system, it cannot be held or suspended.

To hold a job:

  1. Right-click the job on the Job Activity window.

  2. Click Job Control > Hold/Stop.

    Note: You can also stop the workflow from the Informatica PowerCenter side.

Releasing/Resuming a Job

Adapter jobs are resumed in the same way as any other Scheduler jobs.

Note: To resume a workflow, make sure the Enable HA recovery option is turned on in the Workflow Properties on the Informatica PC side.

To resume a job:

  1. Right-click the job on the Job Activity window.

  2. Click Job Control > Release/Resume. This resumes the job that has been held or stopped.

Canceling/Aborting a Job

Adapter jobs are aborted in the same way as any other Scheduler jobs.

Note: If a task is in the "Stopped" status it is not possible to abort it.

To abort a job:

  1. Right-click the job on the Job Activity window.

  2. Click Job Control > Cancel/Abort.

    Note: You can also cancel the workflow from the Informatica PowerCenter side.

Rerunning a Job

Sometimes, you may need to rerun an Adapter job.

To rerun a job:

  1. Right-click the job on the Job Activity window.

  2. Click Job Control > Rerun.

Making One-time Changes to an Adapter Job Instance

Before running or rerunning, you can edit data. To edit the job before running it, set the option as Require operator release on the Options tab in the Adapter Job Definition dialog. Use this function to make changes to an Adapter job after it enters Waiting on Operator status as described in this procedure.

To make one-time changes:

  1. Double-click the job on the Job Activity window. The Job Details dialog displays.

  2. Click the Informatica PowerCenter job tab.

  3. Make the desired changes to the job and click OK to close the Job Details dialog.

  4. If this job is Waiting on Operator, perform one of these tasks:

    • To release the job, click Job Control > Release.

    • To rerun the job with changes, click Job Control > Rerun.