100 job in one Sequence Job

vitumati · Post by **vitumati** » Thu Mar 10, 2011 11:40 pm

Helo Friends,

In my project I've requirement like...

I develop 100 jobs all independent each other(no dependency) But I need to design one sequence to trigger all jobs at a time.

Thanks.....!!
VijayKumar T

chulett · Post by **chulett** » Thu Mar 10, 2011 11:49 pm

Curious what you think is going to happen to your poor Windows server when you attempt to start 100 jobs (parallel or otherwise) at anything approximating the same time?

vitumati · Post by **vitumati** » Fri Mar 11, 2011 12:33 am

chulett wrote:Curious what you think is going to happen to your poor Windows server when you attempt to start 100 jobs (parallel or otherwise) at anything approximating the same time?

My QUESTION IS HOW I DESIGN 100 JOB IN ONE SEQUENCE ?

I'M NEW TO SEQUENCES?

ray.wurlod · Post by **ray.wurlod** » Fri Mar 11, 2011 2:33 am

First off, don't shout (all capitals is "shouting" and bad netiquette).

You can program 100 jobs by adding 100 Job activities to the sequence.

You will then grind your server into dust trying to execute them. You have been warned.

MT · Post by MT » Fri Mar 11, 2011 2:42 am

Hi Vitumati,

depending on what you mean with

vitumati wrote:
... But I need to design one sequence to trigger all jobs at a time.

you could design a single sequence where you add a sequence to your jobs - even they are independend - in order to decrease the parallelism which will kill your machine (see the other comments).
So if you design for example 4 starting jobs and link 24 other activities to each of the starting job you will have aparallelism of four.
If your server is able to handle this you could try 6 parallel streams.

If your requirement means to start 100 jobs simultanously then I can only wish you luck and a short way to your servers reboot button

regards
Michael

DSXchange

100 job in one Sequence Job

100 job in one Sequence Job

Re: 100 job in one Sequence Job