Hi Ahmed,

MRS stores only the metadata of schedule, and the run time stats are fetched from Monitoring MRS.

You can CLICK HERE to view KB containing details about  views having run stats for monitoring MRS.

Regards,

Shreejeet Sahay

Mapping execution statistics would be stored in the database schema used with 'Monitoring MRS' service of the Informatica Domain. However, as the information in the underlying tables would not be stored in easily recognizable data format and also due to design changes of underlying tables, time and again between versions,  there are no direct SQL queries for fetching the execution details from the MRS database schema.

Starting from Informatica 10.2.2 version, it is possible to get the statistics related to the mapping execution through 'REST API calls'  using 'Rest Operation Hub'  (ROH) service.

In the ROH service, there is an REST API named 'MappingStats', which when executed with mapping execution instance id, it would give different execution statistics of the mapping as response in JSON format. JSON response would contain many fields and some important fields among them are as follows:

• Mapping Name
• Application Name
• Execution Mode
• Execution Status
• Start Time (in Unix Epoch)
• End Time (in Unix Epoch)

To get the details of all the execution JobIDs, following command can be run in the Mapping logs location (Default: $INFA_HOME/logs/[node]/services/DataIntegrationService/disLogs/ms )

find $PWD -type f  | grep $PWD/ | xargs -I {} grep  -e 'job to the Integration Service.  Job ID :' {} | awk -F']' '{print $2}' | awk -F'[' '{print $2}'

For more information on the ROH service and instructions related to usage of the service and its API, refer to the following documentations and KB articles:

https://docs.informatica.com/data-engineering/data-engineering-integration/10-4-1/administrator-guide/appendix-b--monitoring-rest-api.html

https://docs.informatica.com/data-engineering/data-engineering-integration/10-4-1/administrator-guide/appendix-b--monitoring-rest-api/mappingstats.html

https://knowledge.informatica.com/s/article/571632?language=en_US

https://knowledge.informatica.com/s/article/573009?language=en_US

Alternative approach for the current requirement is using the Cloud service - 'Operational Insights'  - from IICS platform, which would automatically gather the execution details from the Informatica Domain and give the job report for a selected period. For more information related to the service, refer to the following documentation:

https://docs.informatica.com/operational-insights/operational-insights/current-version/operational-insights/monitoring-data-engineering-integration-domains/viewing-data-engineering-integration-job-analytics/viewing-job-execution-data.html

Hi Aziz,

Could you please let us know If above answer helped in addressing your query> If yes, can you mark the answer as helpful?