How to execute jobs in parallel from while loop of sql server

Question

How to execute jobs in parallel from while loop of sql server

Rajeshpalo

Mr or Mrs. 500

Points: 567
More actions
August 20, 2012 at 2:53 am

#262965

Hi,
How to execute a job and loop through it until you have 5 jobs running in parallel(same job name)
Is it possible to run same job name 5 times at a time?
Thanks in Advance.
Cheer's
Rajesh
Cheer's
Rajesh

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246950 More actions · Answer 1

rajeshpalo2003 78748 (8/20/2012)
Hi,
How to execute a job and loop through it until you have 5 jobs running in parallel(same job name)
Is it possible to run same job name 5 times at a time?
Thanks in Advance.
Cheer's
Rajesh

SSIS packages do not contain while loops (except, possibly, within scripts) and do not have the concept of jobs either.

Is this even an SSIS question? If so, can you be more careful with your terminology and try to clarify your question please?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Rajeshpalo Mr or Mrs. 500 Points: 567 More actions · Answer 2

Thanks for your reply.

My SSIS package is configured by job.so i want to execute that job through stored procedure and i am try to execute that job 5 times parallel with same name instance.

SP Query eg:-

--------------

WHILE (@CntStart < @CntEnd)

BEGIN

WAITFOR DELAY '00:00:00.05'

EXEC msdb.dbo.sp_start_job N'Dynamic_Mapping'

SET @CntStart = @CntStart + 1

END

is it possible?

Cheer's

Rajesh

Cheer's
Rajesh

Phil Parkin SSC Guru Points: 246950 More actions · Answer 3

rajeshpalo2003 78748 (8/20/2012)
Thanks for your reply.
My SSIS package is configured by job.so i want to execute that job through stored procedure and i am try to execute that job 5 times parallel with same name instance.
SP Query eg:-
--------------
WHILE (@CntStart < @CntEnd)
BEGIN
WAITFOR DELAY '00:00:00.05'
EXEC msdb.dbo.sp_start_job N'Dynamic_Mapping'
SET @CntStart = @CntStart + 1
END
is it possible?
Cheer's
Rajesh

Not possible as far as I know. SQL Server jobs can have only one instance at a time.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 4

Rajesh

As far as I know, you can't have the same SQL Server job running more than once at any one time. If you are only ever going to need to run it five times at once, why not create five different jobs? Or, you could put all your job logic into an SSIS package and call that package as many times you like at once.

John