I have CSV files that I want to automate via DemandTools, but I'm clearly facing an issue.
I have a dev box that is always on.
I created the scenarios and scheduled jobs myself on the dev box (locally active).
I set up two import scenarios and one merge scenario, all linked to scheduled jobs.
Each job is configured to override the respective CSV files (refreshed every night via Power Automate), and the new files are stored in a SharePoint location.
The entire SharePoint folder has been set to "Always keep on this device."
My issue is that the scheduled jobs run as expected but don't seem to capture the data from the new files (import).
For the merge job, it runs, but no records are processed.
However, when I run the job manually ("Run Now"), DemandTools processes the new records correctly without errors, which indicates that my files are properly updated.
Thanks for your help!
@Reno - Interesting. Is the job using a different file path potentially when you run it on your machine versus the devbox? What sounds to be happening, is the file path is not being able to be pulled when the job is set to process. Besides the file being available, if the path changes in anyway, a scheduled job won't work. Let me know your thoughts!
