First post here, so please be kind!
I have a bit of a problem with a set of SQL Agent jobs (SQL Server 2014, running on Windows server 2012 R2) that I am trying to setup.
Each job is a multiple step job running as follows:
- SSIS Step
- SQL Command (checks the load of the SSIS)
- System Command (runs a remote batch file via PSExec)
- SQL command (checks the status of the prior batch)
The Batch job that we are running via PSExec can take up to an hour to complete. Also, we have not choice but to run the batch file remotely.
What is happening is while the PSExec command is running, all other SSIS steps in all other jobs hang (even those not related apart from the fact that they are SSIS jobs). As soon as the PSExec step completes, the SSIS jobs start.
Has anyone experienced this before? Does anyone have a work around that we could implement?