I have several SQL scripts that need to run to prep data for a final script. How can I run the pre-process scripts concurrently? Then how can I determine when they have completed so I can launch the final processing script?
You need to look into PowerShell jobs. Specifically these three commands: