Dynamics 365 Retail AxDB tables to scheduler sub-jobs

Sometimes, when pushing data down your retail channel database, to integrate Dynamics 365 Retail HQ with a Retail Store or a Store-Front you might not be 100% sure which scheduler sub-job covers which D365-FO table.

To find which Retail Scheduler Job synchronises a specific AX table to the Retail Channel database you can use the following T-SQL Query against the AxDb:

SELECT [JOBID]
FROM [AxDB].[dbo].[RETAILCONNSCHEDULERJOBLINE]
WHERE [SUBJOBID] = 'your_ax_table_name'

The above snippet assumes your are on a Tier-1 build one-box or a locally hosted dev-box where the database is normally called "AxDB". In other scenarios (for example in Tier-2+ Azure SQL databases), you might need to update the SQL statement accordingly.

In the "JOBID" column you will get the resulting ID of the associated job which you can then execute or schedule as sub-job from the "Distribution schedule" screen with D365-FO/Retail HQ i.e. "&mi=RetailCDXSchedule"
Example in screenshot below.