01-05-2018 11:06 AM
I am trying to set up a schedule for a process flow that has 14 programs that must run in a specific order. When I manually run the sas program from the EG (run project) the program runs without error in the correct order. When I set up a schedule for that process flow it seems that when the schedule is executed it does not follow the same order as it does when you manually open EG.
How do I control the run order in the scheduled job, I assume I have to change the .vbs file somehow. currently .vbs it is just the default that is created when schedule is set up.
01-05-2018 11:15 AM
Look at ordered lists in EG. Also, do you have your programs connected in your process flow one after the other? That should also force it to run in order.
01-08-2018 03:09 PM
I did not have the programs linked. I assumed if there was no link it would run the same order in schedule process as clicking run program in EG. For ease of following all the code I have separated code into different programs as macros and then trigger them all at once in another program (SQL connection to source data on another server) so no automatic link is set up, have to manually add it. Once linked the program runs correctly. The schedule appears to ignore the ordered list in EG.