Microsoft SQL Server CDC Connector

Back Next

Monitoring a mapping task

After you run a mapping task, you can check the job status for the task to determine if the job succeeded, completed with warnings, or failed. If the job failed or ended with a warning, you can view the session log for the job to identify the error or warning conditions. For continuous mapping tasks, you can stop the mapping task from the Monitor.

Each time a user or schedule starts a mapping task, Informatica Intelligent Cloud Services creates a job to run the task.

To view a list of mapping task jobs, use one of the following methods:

Data Integration

, select

My Jobs

. The

My Jobs

page lists all jobs that you, the user who is currently logged in, started. It does not include jobs that were started by a schedule.

In Monitor, select

All Jobs

Running Jobs

. The

All Jobs

page lists all of the running and completed jobs that members of your organization started or that were started by a schedule. The

Running Jobs

page lists only the jobs that are currently running or that have completed within the last 5 minutes.

On the

My Jobs

All Jobs

, or

Running Jobs

page, review the information about the jobs you're interested in. The following information is displayed by default and shown for each job instance:

Start date and time

End date and time

Number of rows processed

Current state, which can be one of the following values: Queued, Starting, Running, Success, Stopped, Suspended, Warning, or Failed.

You can change the columns that are displayed by right-clicking the column-heading area and selecting or deselecting column names in the list.

For more information about a job, click the job name to open a page that contains job details and a download link for the session log. You can also download the session log by moving the cursor to the right end of the row for a job and clicking the

Download Log

icon.

To stop a Running job, hover the cursor over the Running job status and select the Clean Stop or Stop icon. Clean Stop attempts to complete the any change capture processing that is currently in progress before stopping the task. Stop ends the task immediately, regardless of whether change capture processing is complete.

If the job state is Failed or Warning, gather more information about the error or warning condition in the following ways:

For a Failed job, hover the cursor over the Failed icon in the

State

column. A brief description of the error condition appears, which you can copy.

Download the session log and look for error or warning messages that begin with the message ID prefix of "PWXPC" or "PWX."

If possible, correct the error or warning condition and then restart the job. To restart the job from the

Jobs

My Jobs

page, move the cursor to the right end of the row for the job and click the

Restart

icon. If you set the

Recovery Strategy

session property to

Resume from last checkpoint

, the job restarts extraction processing from the recovery point that is recorded in the state table or state file on the target system to ensure that no change data is lost.

Rename Saved Search

Table of Contents

Microsoft SQL Server CDC Connector

Microsoft SQL Server CDC Connector

Monitoring a mapping task

Monitoring a mapping task