How to create a recurring data job for a Data Management export to BYOD

(0) Share

Report

Posted on by jallred

Using D365 F&O, I created a Data Management project that exports Data Entities successfully to my BYOD database when I manually click the Export button. However, I need to run this on a daily schedule. So, I click on "Create recurring data job", provide the relevant information and click OK. I get an error message "At least one client id must be enabled for the recurring data job before it can be activated."

Some posts in this forum suggest that maybe the Application ID is required and that is the cause of this error message. I'm not sure why this would be the case if I can run it manually, or how to generate an Application ID for an export that isn't really using an application, only a database.

Please help. Thanks.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (1)

Report

Hi jallred,

When you create a export data project, set 'Target data format' to the AzureSQLDB. You can activate 'Export across all companies' to export data for all companies.

Then click on Export options > Export in batch and create a recurrence.

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Regarding creating recurring data job (the screenshot that you have attached), you need to add the application ID of the app registration. Ref. to my previous feedback, you can apply batch job to export data to AzureSQLDB.

Was this reply helpful? Yes No