Apr 162012
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
See Answers
source: http://stackoverflow.com/questions/1681906/launch-multiple-stored-procedures-to-run-in-the-background-on-sql-server-expre
Using sql-server: using-sql-server
Recent Comments