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
What is the difference between informatica and datastage?
Describe routines in datastage? Enlist various types of routines.
Where do the datastage jobs get stored?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is meta stage?
What are stage variables?
What are the difference types of stages?
Define project in datastage?
Why we use surrogate key?
AGGREGATOR default datatype
Define ds designer?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Define Merge?
Which warehouse using in your datawarehouse
how do u catch bad rows from OCI stage? And what CLI stands for?