On the My Jobs page, you can monitor the jobs for the data profiling tasks that you run. The page lists the data profiling jobs that were run within the last three days and the 1000 most recent jobs that are more than three days old.
The following image shows the My Jobs page in Data Profiling and the actions that you can perform on the page:
1View. Right-click a property name to choose the properties that you want to view on the page.
2Refresh. Refresh the page to view the current information about the jobs.
3Sort. Choose a property to sort the properties in ascending or descending order.
4Filter. Add one or more properties and enter values to filter the results.
5Find. Enter a keyword to search for results.
The status message at the top of the page indicates whether the information on the page is up-to-date. If the information is out-of-date, the status message displays Updates Available. To refresh the page, click the Updates Available message or the Refresh icon.
When a job completes, you can drill down on the job to view the job details. To drill down on a job, click the instance name.
For more information about monitoring jobs, see Monitor in the Monitor help.
Job properties
The All Jobs, Running Jobs, and My Jobs pages display the job properties such as the name, start time, and status. You can right-click the column heading area to display or hide specific properties.
By default, the following properties are displayed for each data profiling job:
Property
Description
Instance name
Name of the job.
Location
Project and folder path where the task exists.
Subtasks
Shows the number of subtasks created for the job. To view the job properties, click the entry in this column.
To close the subtask view, click Data Integration from the menu at the top of the page.
Start time
Date and time that the job was started.
End time
Date and time that the job completed or stopped. Does not apply to running jobs.
Rows processed
Number of source rows processed by the job.
Status
Job status. A job can have one of the following states:
- Starting. The job is starting.
- Running. The job is still running.
- Success. The job completed successfully.
- Warning. The job completed with errors.
- Failed. The job did not complete because it encountered errors.
When a job is in Running status, a Stop icon appears in the Status property. Click the icon to stop the job.
You can display the following additional properties by right-clicking in the column heading area:
Property
Description
Asset name
Name of the data profiling task.
Asset type
Type of asset that is associated with the job. For data profiling task jobs, this column displays "Data Profiling Task."
Runtime environment
Runtime environment in which the job ran.
Duration
Amount of time the job ran before it completed or was stopped.
Success rows
Number of source rows processed successfully by the job.
Failure rows
Number of source rows that failed for the job.
Started by
Name of the user or schedule that started the job.
Error message
Error message, if any, that is associated with the job.
When you click an instance name, the job details for the data profiling job appears. The job details include the instance name, asset name, asset type, started by, start time, end time, duration, state, and error message.
Subtask types
When you run a data profiling task, a job instance is created for the profile run. Data Profiling creates subtasks based on the options that you choose for the profile run.
To view the subtasks for a job, click the subtask link in the Subtasks column. The subtasks created for the job appears.
Data Profiling creates the following subtasks based on the profile options that you choose for the profile run:
Subtask Name
Description
Fetching the source row count
Fetches the row count for the profile run.
This subtask is created only once for a profile run.
Generating data profiling mappings
Gathers statistics based on the advanced options that you choose for the profile run.
This subtask is created only once for a profile run.
s_profiling
Runs the profile and saves the results to a secure and encrypted staging area. This subtask is created multiple times based on the advanced options for the data profiling task. For information about the advanced options, see Data Profiling.
The staging area is a temporary location in the Informatica Intelligent Cloud Services repository.
Loading data from staging area to metric store
Loads the data from the staging area to the metrics store. This subtask is created only once for a profile run.
The metrics store is located in the Informatica Intelligent Cloud Services repository where the encrypted profile results are stored. When you choose a profile run number to view the results, the service gets the profile results from the repository.
To view the details for each subtask, click the subtask link in the Instance Name column. The subtask details include instance name, asset name, asset type, started by, start time, end time, duration, state, and error message. Additional details appear for the s_profiling subtask which include processed rows, success rows, error rows, and session log. Click the Download Session Log to download the session log file.
You can view the runtime environment and the Secure Agent for the following subtasks in Data Profiling, Monitor, and Operational Insights:
•Fetching the source row count
•s_profiling
•Drilldown
•Query
Note: The Runtime Environment field displays the name of the Secure Agent Group.
You can view the following details for the Secure Agent in the session log file for the profile mapping jobs:
•Task Name. The name of the profiling task.
•Agent Group Id. The ID of the Secure Agent Group.
•Agent Group Name. The name of the Secure Agent Group.
•Agent Id. The ID of the Secure Agent.
•Agent Name. The name of the Secure Agent.
Stopping and restarting data profiling jobs
You can stop and restart data profiling jobs. Stop a job on the All Jobs, Running Jobs, or My Jobs page. Restart a job on the All Jobs or My Jobs page or from the job details.
You can perform the following actions:
Stop a job.
You can stop a data profiling job that is running or queued.
To stop a job, open the All Jobs, Running Jobs, or My Jobs page. Then click the Stop icon in the row that contains the job that you want to stop.
Restart a job.
You can restart a data profiling job that has failed.
To restart a job on the All Jobs or My Jobs page, click the Restart icon in the row that contains the job that you want to restart.
To restart a job from the job details, click Restart at the top of the page.
Downloading a log file
You can download the log file for a data profiling job that has completed or failed.
1In Monitor, select All Jobs or Running Jobs, or in Data Profiling, select My Jobs.
2Click the number of subtasks in the Subtasks column to open the subtask view.
