I have got a powershell script which accepts a list of servers in an array as a parameter, let us assume a list of 10 servers are passed
The array is passed onto a workflow.
The workflow uses the parallel functionality to operate on multiple servers at once.
The workflow uses an inline script.
For every server called in the foreach parallel within the workflow, invoke-sqlcmd will be called to deploy 5 files.
How can the error action be changed such that for every server, if there was a failure on server 3, the script should move onto server 4. however if there is an error on script number 3 out of the 5 script files deployed per server, the deployment should stop onto that SQL server but move onto the next one ?