Overview:
The following two Medical Inquiry Pull jobs are both scheduled to run Hourly.
- Medical Inquiry (Recurring Account Pull)
- Medical Inquiry (Recurring Inquiry Pull)
But the jobs are constantly failing with the error: Prior CRM Data Sharing job not yet complete.
Root Cause:
The two Medical Inquiry Pull jobs interfere with each other. A check is done before they run to ensure all others have finished.
When the jobs are scheduled Hourly, they are executed simultaneously at 0 minutes past the hour. Hence, the error occurs.
Solution:
The recommendation is to run the two Medical Inquiry Pull jobs several minutes apart, for example at HH:00 (Account Pull) and HH:15 (Inquiry Pull). Unfortunately, it's not possible to configure this through the UI, it must be done via the API by executing MDL Script, for example using Postman.
Here is the MDL Script that can be executed to set the running time of the job Medical Inquiry (Recurring Inquiry Pull) to 00:15'.
ALTER Job crm_pull_recurring_inquiries__v ( schedule('hourly'), hourly_interval(1), time('00:15') );
*** Callout Section ***
Note: It is not reflected in the UI when admins make the change. But when checking the job history, admins should see it running at the right time. And if admins subsequently change it in the UI, it will revert back to HH:00.
Related Documentation:
Vault Help Documentation: Execute MDL Scripts