What links the recurrning job with the DMF job?

(2) Share

Report

Posted on by ..

1,979

Hi,

In recurring jobs, i need to go inside execution details, to know to which DMF run it is linked to.

1. Can't i know it from the recurring jobs form itself?

2. i thought activityRunTimeExectutionCorrelationId would be the field but it's not, what is this field?

so here from execution details, i was able to get the job Id

then when i went to DMF, i was able to find it by looking at execution group id

3. another question is, we know that for each recurring job, there is a batch running, For this one, how can we also relate it to the correct DMF job and to the correct recurring Job record?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Saif Ali Sabri

2,351 Super User 2025 Season 2 on at

Like (0)

Report

To address your questions clearly and provide a solution for linking Recurring Data Jobs with DMF (Data Management Framework) executions, here's a step-by-step breakdown of the relationships and how to trace them efficiently in Dynamics 365 Finance and Operations (D365FO).

✅ 1. Can I see the DMF job ID directly from the Recurring Jobs form?
No, the DMF job ID (DMFDefinitionGroupExecution record) is not directly shown in the Recurring Data Job form (DMFRecurringDataJobTable).
You must open the Execution details to find the associated job.
However, you can customize the grid or create a view (or query) to include the ExecutionGroupId or related DefinitionGroupExecutionId.

✅ 2. What is ActivityRunTimeExecutionCorrelationId?
This field is used for Power Platform Data Integrator (CDS/Dataverse) scenarios. It's a correlation identifier to help link data runs from external integrations (like Power Automate or Power Apps).
It does not link to the DMF job directly — so it’s not useful for tracking recurring DMF runs.

✅ 3. How to relate the batch job with the recurring job and the DMF execution?
Every Recurring Data Job spawns a Batch Job that executes a DMF import/export.
📌 Here’s how you can link them:

Component	Table Name	Key Fields / How to Join
Recurring Data Job	DMFRecurringDataJobTable	RecurringJobId
Recurring Job Execution	DMFRecurringJobExecution	Has DefinitionGroupExecutionId, RecurringJobId
DMF Job Execution	DMFDefinitionGroupExecution	Join on DefinitionGroupExecutionId
Batch Job	BatchJob / Batch tables	Use CorrelationId (GUID from execution)

✅ Steps to trace:

Start from DMFRecurringDataJobTable with your RecurringJobId.
Go to DMFRecurringJobExecution to get DefinitionGroupExecutionId.
Go to DMFDefinitionGroupExecution for job details.
In BatchJob, look for jobs with Description or Parameters that include:
- The DefinitionGroupExecutionId or
- Use the CorrelationId GUID found in DMFRecurringJobExecution.

🎯 Suggested SQL/X++ tracing logic:
If you're building a query/report:
sql
CopyEdit
SELECT R.RecurringJobId, E.DefinitionGroupExecutionId, D.DefinitionGroupName, B.BatchJobId
FROM DMFRecurringDataJobTable R
JOIN DMFRecurringJobExecution E ON R.RecurringJobId = E.RecurringJobId
JOIN DMFDefinitionGroupExecution D ON E.DefinitionGroupExecutionId = D.DefinitionGroupExecutionId
LEFT JOIN BatchJob B ON E.CorrelationId = B.CorrelationId
Adjust field names as needed depending on customization/version.

✅ Summary: End-to-End Link

Step	Source Table	Key Field
1. Recurring Job	DMFRecurringDataJobTable	RecurringJobId
2. Executions	DMFRecurringJobExecution	DefinitionGroupExecutionId
3. DMF Job	DMFDefinitionGroupExecution	Execution details
4. Batch Job	BatchJob	CorrelationId (matches Execution record)