Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
atulgoel
Participant
Posts: 84 Joined: Tue Feb 03, 2009 1:09 am
Location: Bangalore, India
Post
by atulgoel » Wed Aug 26, 2009 3:08 am
Hi,
How to run the Shell script through DS job?
Thanks Atul
miwinter
Participant
Posts: 396 Joined: Thu Jun 22, 2006 7:00 am
Location: England, UK
Post
by miwinter » Wed Aug 26, 2009 3:17 am
Call it in a before or after job routine.
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
atulgoel
Participant
Posts: 84 Joined: Tue Feb 03, 2009 1:09 am
Location: Bangalore, India
Post
by atulgoel » Wed Aug 26, 2009 3:29 am
Thanks Marks..
Can I call the ExecSH routine in the job.? My requirement is to execute the script on the output file of the job.
Please help to how can i do it?
Thanks
Atul
Atul
miwinter
Participant
Posts: 396 Joined: Thu Jun 22, 2006 7:00 am
Location: England, UK
Post
by miwinter » Wed Aug 26, 2009 3:36 am
Yes, employ ExecSH in an after-job routine.
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
atulgoel
Participant
Posts: 84 Joined: Tue Feb 03, 2009 1:09 am
Location: Bangalore, India
Post
by atulgoel » Wed Aug 26, 2009 4:04 am
Thanks..
I am first time using this. Can You please guide me how can I call this in my job?
Thanks
Atul
miwinter
Participant
Posts: 396 Joined: Thu Jun 22, 2006 7:00 am
Location: England, UK
Post
by miwinter » Wed Aug 26, 2009 4:11 am
Please refer to the documentation - it's in the Designer guide.
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Aug 26, 2009 5:33 am
Those options are part of the job Properties page, you'll see an entry for both 'before' and 'after' job actions there. Change the after property to ExecSH and then put the full path to the script in the box next to it.
-craig
"You can never have too many knives" -- Logan Nine Fingers
RAJARP
Participant
Posts: 147 Joined: Thu Dec 06, 2007 6:46 am
Location: Chennai
Post
by RAJARP » Wed Aug 26, 2009 8:33 am
Hi atul,
One more approach is that, you can do that in a job sequence also.
Parallel job ---->Execute command activity
Inside Execute command activity , by giving proper command and parameters ,you can execute the script on your output file
Regards,
Raja R p
arnabdey
Participant
Posts: 50 Joined: Wed Jan 10, 2007 5:56 am
Post
by arnabdey » Wed Aug 26, 2009 10:12 am
Hi
Go to properties tab, you will find two options as before job and after job subroutine. Use ExecSh or ExecShSilent as per your requirements (the second one is appropriate if you are using userid/passwords as parameters to the script). If you want to execute it before your job starts use the before job routine or if it is to be executed at the end use after job routine). Remember you should provide the absolute path of the script to be on safer side, followed by its parameters.
Arnab