DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Cherukuri
Participant



Joined: 25 Jul 2007
Posts: 46
Location: India
Points: 598

Post Posted: Thu Nov 03, 2011 9:53 am Reply with quote    Back to top    

Hi,

I have a text file which contains the names of few job sequences new line delimiter.
Now I am developing a sequence job which will only run those sequences whose names are retrieved from the text file.

(i) I call an script which gives me the names of the sequences.
(ii) I store all the names of in UserVariable.
(iii) Then I start a loop activity which takes the names one by one.
(iv) I applied a job activity stage,but cannot get the value i.e the sequence name to run from the file in the Job Name tab of the job activity.


Could you please suggest me whether the design is correct or it has to be done in some other way?

Hope I am able to explain the requirement.

Thanks and Regards,

_________________
Cheru
BI-RMA



Group memberships:
Premium Members

Joined: 01 Nov 2009
Posts: 463
Location: Hamburg
Points: 3699

Post Posted: Thu Nov 03, 2011 10:16 am Reply with quote    Back to top    

Take a look at the Routine UtilityRunJob (Routines-->sdk-->Utility).

You can run this from a server job. Read your file with the job names, add parameters you need and provide these as input to the Routine.

Your jobs/sequences will then be executed sequentially by the server job.

_________________
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54194
Location: Sydney, Australia
Points: 293930

Post Posted: Thu Nov 03, 2011 12:37 pm Reply with quote    Back to top    

Wrong forum. This forum is for posting suggestions for FAQ topics.

DataStage questions should be posted in the appropriate forum, so that we can gain some insight into which edition you're using and which version and platform.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42520
Location: Denver, CO
Points: 218805

Post Posted: Thu Nov 03, 2011 1:06 pm Reply with quote    Back to top    

Moved.

Cherukuri - please go back and edit your post to include the details we're missing right now: Version, Job Type & O/S .

_________________
-craig

I know I don't say this enough, but I like when you talk to me. It's much better than when nobody talks to me. Or when people that I don't like will not stop talking to me.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours