Page 1 of 1

Multi Instance Job

Posted: Tue Jan 24, 2012 11:06 pm
by vskr72
I have a job that read a Seq file and some transformation before the data loads into a table. This job is parameterized to read 2 types fo files (lets say A and B). Some times based on the availability of A and B file, the job could have two run instances at the same time. Other times it could be sequential run for A followed by B or vice versa. So I have few questions?

1. SInce the file names are different (even thought the same job is used), should it be configured for a multi instance jon.
2. I tried running a test job thru command line with Instance name suffix to the job name, the Job ran fine. It it was not showing any run statistics in the designer. IS that common. Am I missing anything?

Thank you for your inputs

Posted: Tue Jan 24, 2012 11:13 pm
by chulett
1. If you want to be able to process A and B at the same time, yes.

2. Yes, that's how it works. The Designer only shows stats for "non multi-instance" job runs.