08-23-2016 11:19 AM
I feel a little stuck with running jobs from a batch file.
Need some help with basic DOS stuff.
I've been looking here:
My question is: how to combine the examples 5 and 6 in a single batch file?
Run Job1 and wait for it to finish
Run Job2 and Job3 simultaneously (to save time) and wait for both to finish
Run Job4 to combine the results from Job2 and Job3
I've been tinkering with it but could not make the jobs 2 and 3 run in parallel and make 4 wait for both of them to complete before executing.
For now I'm looking for a simple solution, without Powershell.
08-24-2016 11:06 AM
Because this is the first time I hear about MP Connect and also we do not have SAS/Connect in our purchase order. What we have is SAS EG, SAS BI server and the SAS/Access modules.
08-24-2016 07:43 PM
SAS BI Server includes SAS/Connect
1 minute on google would have told you the same thing.
08-29-2016 12:19 PM
MP Connect looks promising. I checked and SAS/Connect is not part of our order. Also it is not under the BI Server deployment plan. It shows up in the Appdev plan though. So, not gonna happen for us.
08-24-2016 09:02 PM
You mention DOS. If you are batching this on a single pc, you are unlikely to gain much by running Jobs 2 and 3 concurrently. Many SAS jobs use a lot more I/O than CPU and there is only one I/O path on most PCs. Even with multiple servers, you may not see much gain unless the data are spread across multiple drives and you are running multi-gigabit pipes between the data and the servers.