When a job is run manually it works, however the schedule finds no data to process
I created a map that runs a query using ODBC connection to find new items that do not have sites set up. When run manually the map works perfectly, however when it runs on schedule it doesn’t find the data. Looking at the event logs I see the difference is that the automated job runs on the Server with the GP database, whereas the manual job runs on our terminal server that users log into. I checked and I do have ODBC set up on that machine under the admin profile. I created a system DSN with same name that is set in the Map but the errors persist. Is there something in my ODBC connection string that needs modification?
If you would like to submit an answer or comment, please sign in to the eOne portal.