j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do
this using sequencer?
2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?

Answer Posted / sbhash

1. Connect J2 to J1 and J3. Connect J2 to J1 and
J3. 'Expression Type' as 'OK -(Conditional) or Custom -
(Conditional)' and for 'Custom - (Conditional)', put
constraint as J2.$JobStatus < 3.

2. Create a sequence without any Links between these jobs
and rund then those jobs will run in parelell.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2123


How a routine is called in datastage job?

609


What is a ds designer?

643


Could anyone give brief explanation bout datastage admin

1973


What are the different type of jobs in datastage?

608






Define Job control?

680


What is the purpose of pivot stage and types of containers in datastage

613


What is the purpose of interprocessor stage in server jobs?

1727


how to delete one row in target dataset

2588


How to perform incremental load in datastage?

672


How can you write parallel routines in datastage PX?

621


What all the types of jobs you developed?

667


How the ipc stage work?

678


how to sort two columns in single job in datastage.

2536


DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1039