Hi Gus,
Can u pls tell me
How can u Call the Shell Scripting/Unix Commands in Job
Sequence?

Answer Posted / pavan

Hi,

There are two scenarios where u myt want to call a script

Scenario 1(Dependency exists between script and a job):
Where a job has to be executed first then the script has to
run, upon completion of script execution only the sec job
has to be invoked. In this case develop a sequencer job
where first job activity will invoke the first job then
using Execute command activity call the script u would
desire to invoke by typing "sh <script name>" in the
command property of the activity, then with the other job
activity call the second job.

Scenario 2: (Script and job are independent) : In this case
right in your parallel job say job1, under job properties u
can find "After-job subroutine" where u need to
select "ExecSH" and pass the script name which you would
like to execute. By doing this once the job1 execution
completes the script gets invoked. The job succeeding the
job1 say job2 doesnt wait for the execution of the script.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between informatica and datastage?

666


Describe routines in datastage? Enlist various types of routines.

595


Where do the datastage jobs get stored?

745


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

979


What is meta stage?

592






What are stage variables?

649


What are the difference types of stages?

640


Define project in datastage?

680


Why we use surrogate key?

708


AGGREGATOR default datatype

951


Define ds designer?

782


what is 'reconsideration error' and how can i respond to this error and how to debug this

2127


Define Merge?

889


Which warehouse using in your datawarehouse

1690


how do u catch bad rows from OCI stage? And what CLI stands for?

2302