Multiple Instance from Unix
Moderators: chulett, rschirm, roy
Multiple Instance from Unix
Hi
I have a requirement to run a single Datastage job sequencer for different files for in same format at the same time...
But I do not need to create physical job sequencers for each one...I am scheduling the Job sequencers via Unix cron using DSJOB -run
How can I call the same job from Unix script at the same time
Say I run DSJOB1 for File1....and the job is running ...I need to run the same DSJOB1 for File2 but using some kind of invocation id logic
please help...
I have a requirement to run a single Datastage job sequencer for different files for in same format at the same time...
But I do not need to create physical job sequencers for each one...I am scheduling the Job sequencers via Unix cron using DSJOB -run
How can I call the same job from Unix script at the same time
Say I run DSJOB1 for File1....and the job is running ...I need to run the same DSJOB1 for File2 but using some kind of invocation id logic
please help...
Avishek Mukherjee
Data Integration Architect
Chicago, IL, USA.
Data Integration Architect
Chicago, IL, USA.
Thanks Kris but I do not want to create a physical job...each job in my casew ould be for a Dealer and I have say 20,000 Dealer so that would be huge number of jobskris007 wrote:You can create the job as a Multi-Instance job and then pass the invocation id as a parameter from the command line. Wouldn't that solve your problem?
Avishek Mukherjee
Data Integration Architect
Chicago, IL, USA.
Data Integration Architect
Chicago, IL, USA.
I didn't mean to create 20,000 jobs. Since you say you have 20,000 dealers I am assuming you would have around 20,000 files and would need to run the same job that many times. Allowing a job to be a Multi-Instance job allows you to do exactly what you want. All you have to do is go to the job properties and check the "Allow Multiple Instance" option. With that selected you can run any number of instances of your job(i.e. run the same job any number of times) as long as you provide unique invocation id's. That is the easiest way I am aware of unless I got your requirement totally wrong.
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
kris007 wrote:I didn't mean to create 20,000 jobs. Since you say you have 20,000 dealers I am assuming you would have around 20,000 files and would need to run the same job that many times. Allowing a job to be a Multi-Instance job allows you to do exactly what you want. All you have to do is go to the job properties and check the "Allow Multiple Instance" option. With that selected you can run any number of instances of your job(i.e. run the same job any number of times) as long as you provide unique invocation id's. That is the easiest way I am aware of unless I got your requirement totally wrong.
I understand that but how can I kick of that job in Unix...via DSJOB -RUN
Aso for DSJOB -RUN I need the Datastage job name as one of the parameters...can I give something like alias.datastage job name.
Then I can run the job multiple times..
Avishek Mukherjee
Data Integration Architect
Chicago, IL, USA.
Data Integration Architect
Chicago, IL, USA.
From what I know it should be
HTH
Code: Select all
dsjob -run project jobname.invocationid
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: