Using sql-server: Launch multiple stored procedures to run ‘in the background’ on SQL Server Express Edition on newest questions tagged sql-server – Stack Overflow
Is it possible to run multiple stored procedures that run ‘in the background’?
The stored procedures must be launched from a single, master stored procedure, in the same way that multiple worker threads are spawned. For example:
CREATE PROCEDURE MyLauncher AS BEGIN BEGIN @EXEC MyBackgroundSP01 -- Runs in parallel to the other 2 @EXEC MyBackgroundSP02 -- Runs in parallel to the other 2 @EXEC MyBackgroundSP03 -- Runs in parallel to the other 2 END END
Using sql-server: using-sql-server