Hello,
I am working on a solution integrated with BC cloud erp. The user wants to have scheduled batch activites importing data from BC via odata and also wants to have some integration activities using the excel destination provider for outputting data for them to reveiw that are run manually on demand. The issue we are running into is that the odata jobs seem to queue up each time their associated scheduled task is triggered regardless if another run of the same task is in the queue. Over the course of the day this queue seems become quite long. When the user goes to try and manually run their export activity it ends up just waiting to run, sometimes for hours as the other activities run mulitple times before the one manually triggered. I have recommended scheduling the exports which does keep them in the queue and running a few times a day, but its something they want to be able to generate relatively on demand. Looking for any suggestions or solutions.
Thanks,
Jeremy Fesmire