BeyondERP.Newsletter
Menu

Setup step on the Scheduler jobs page · Retail and Commerce

Set up Scheduler jobs

Use this page to review which tables each job synchronizes, to add or adjust custom jobs, and to flag a job as excluded from offline databases.

Used by
Retail operations manager, Retail service, Information technology manager
Business process
Manage sales channels
Menu item
RetailConnSchedulerJobTable
Main table
RetailConnSchedulerJobTable
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page listing the Commerce Data Exchange jobs (for example 1040 Products, 1110 Global configuration, P-0001) that move data between headquarters and channel databases; each job groups a set of subjobs and is tied to a channel schema.
What you do hereUse this page to review which tables each job synchronizes, to add or adjust custom jobs, and to flag a job as excluded from offline databases.
ExampleFor example, you can set Exclude from offline databases to Yes on the 1010 customer job so customer data is not copied to store offline databases.
Scheduler jobs page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set up Scheduler jobs

Use this page to review which tables each job synchronizes, to add or adjust custom jobs, and to flag a job as excluded from offline databases.

How to use it

  1. Go to Retail and Commerce > Headquarters setup > Commerce scheduler > Scheduler jobs.
  2. Use the Filter box to find a job; the list is filled by Initialize commerce scheduler.
  3. Select New and enter the Job name and Description, then under General pick the Commerce channel schema and set Is upload and Exclude from offline databases.
  4. Under Subjobs, select New to add the subjobs the job runs, or Mark for exclusion and Remove exclusion to control them.
  5. Select Copy scheduler job to copy a job, and Save.

Source: Checked in Dynamics 365

Fields on the page

FieldWhat it means
Exclude from offline databasesWhen Yes, no data package generated for this job is applied to Store Commerce offline databases.Microsoft Learn
Channel schemaThe channel schema (normally AX7) that defines how headquarters data is read for this job.Microsoft Learn

Test checklist

  1. In a sandbox, set Exclude from offline databases to Yes on job 1010.
  2. Run the job and check on Download sessions that packages for the offline database group no longer include it.
  3. Sign in to Store Commerce in offline mode and check that customer search returns no customers.
  4. Check that only one P-job distribution schedule runs at a time.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Scheduler jobsExclude from offline databases = No, except for jobs whose data isn't needed offline (for example the 1010 customer job when transactions don't need a customer offline)Smaller offline databases are faster and stay within SQL Express limits. Microsoft gives excluding customers as the example when a customer doesn't need to be attached to a transaction, and 1010 is the only customer data job by default.Excluding a job and then running Full data sync for it from Channel database. That empties the related tables in the offline databases.
Solution architect

5Design impact

Can it be undoneHard to reverse: Excluded data stops syncing to offline databases. If a full data sync runs for the excluded job, the related tables in offline databases are emptied and data has to be regenerated after the job is included again.
If you change it laterExcluding a job from offline databases and then running a full data sync clears the affected tables in the offline databases; running more than one upload (P) job in parallel can cause table locks and slowdowns. Microsoft Learn
Technical architect

6Technical

Menu itemRetailConnSchedulerJobTable Checked in Dynamics 365
FormRetailConnSchedulerJobTable Checked in Dynamics 365
TableRetailConnSchedulerJobTableShown as “SCHEDULER JOBS” in Record infoKey field: jobIdChecked in Dynamics 365
Who can open itPrivilegesMaintain Retail scheduler RetailSchedulerMaintainDutiesManage Commerce Data Exchange: Synch Service RetailSchedulerManage
3 security rolesRetail operations manager RetailOperationsManagerRetail service RetailServiceInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceRetail operations manager RetailOperationsManagerInformation technology manager SysServerITManagerGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Copy scheduler jobChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=RetailConnSchedulerJobTable
Table definitionRetailConnSchedulerJobTable columns and relations Microsoft data model
Everyone

8Sources

To cite this step: RC-CDX-010, Set up Scheduler jobs. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/RC-CDX-010