Difference between using multiple instance of a job Vs Copy

[georgesebastian]

Hi All,

From one of the postings about multiple instance says
"Let us assume you have a simple job that you declare as multi-instance. It accepts a source file name as a parameter and all it does is read the sequential file, perform some transformations onto the data and load it into a database table.
You can start this with one job several times in parallel,each instance using a different parameter value for the source file."

So this means the same job can be used for many number of source files.
My Question is what is the difference between using multiple instance of a job Vs Copy of the same job

Thanks
George

[Maveric]

If u want to run the job N number of times simultaneously then u need N copies of the job or one multi instance job with N number of instance IDs and N different inputs. If N is unknown then you wont be able to make enough copies.

[ray.wurlod]

The pronoun you're looking for is "you". We have a user registered called "U" who might take offence.

[Maveric]

Got used to Short Messaging Service language. I will keep that in mind next time i post.

[georgesebastian]

[quote="Maveric"]If u want to run the job N number of times simultaneously then u need N copies of the job or one multi instance job with N number of instance IDs and N different inputs. If N is unknown then you wont be able to make enough copies

Thanks maveric
George