DSXchange

Hi,

I have a sequence where in I have 3 execute commands to FTP 3 different files from server to the datastage server and when the files are FTP'd i have 3 different server jobs to be executed(where in each one of these jobs uses 1 file each).But i want to design sequence in such a way that if i get only File 1 FTP'd successfully than i run only Job1 and not run the other 2 jobs Job2 and Job3.

Any ideas how to design the sequence to achive this functionality.


Thanks.

Hi

Add File watcher in the sequance between each job
or
After FTp1 - Ftp2 and Ftp3

Wait for file1- job1
Wait for file2- job2
Wait for file3 - job3

HTH
Raghu M

rajkraj wrote:Hi,
if i get only File 1 FTP'd successfully than i run only Job1 and not run the other 2 jobs Job2 and Job3
Thanks.

Alternate solution -

Create 3 seperate job sequences and run them seperately

Command Stage (FTP1) ----> Job1
Command Stage (FTP2) ----> Job2
Command Stage (FTP3) ----> Job3

This way you don't need to wait for the file to get FTP'd to start the successive job.

YMMV