I have two Job Sequencers(Say 'SEQ1' and 'SEQ2') which I will execute through the Scheduler in the DS Director. But the
Condition is that I want to schedule the start of execution of the second sequencer 'SEQ2' only after the first sequencer is executed completely. I tried to find out such Conditional scheduling in director but invain. Is such kind of Conditional Schedulling possible through the scheduler in datastage director??
Amit_111 wrote:Thanks....the question was tough but the answer was really simple...thanks once again...
Not tough, really!!
Yet another way is to schedule both sequences with a reasonable time gap. Once SEQ1 completes, execute a job that dumps a file into some directory. SEQ2, however, starts with a Wait-For-File activity (waiting for the file to be created by SEQ1). As soon as it finds it, delete it (or move it to some other directory) and trigger the rest of SEQ2.
Could be helpful in case your sequence jobs are in different projects.
Looks great Gateleys...I will surely give it a try and let you know.......Also thanks DSGuru.....I will suggest my client regarding these ideas so as to ease things lets see how much I succeed