As I understand it, SQL Server Agent runs only one instance of a job (SSIS Package in this case) at a time.
I need it to Start a job 15 times, and then let them all run at the same time.
Up to now, I have accomplished this quite successfully, manually, by right clicking on the job and selecting "Execute". But i need to automate this now.
- I have tried to schedule the job to start 15 times, but it only works sequentially. (1 job after the other)
- I created 15 separate jobs and started them, but the first one starts and the others not, stating the job is already in use.
Should I look at another scheduling tool to accomplish this?
Any pointers would be welcome.....