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.
Sequence
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 24
- Joined: Fri Aug 26, 2005 3:52 pm
- Contact:
Re: Sequence
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
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
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
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.