Page 1 of 1
Alternate way without using sequencer
Posted: Wed Jun 16, 2010 5:03 am
by sirishds
Hi,
I have a couple of jobs need to be executed sequentially but i am not supposed to use sequencer is there any alternative way to perform the control flow of jobs.
Thanks in Advance
Sirish.
Posted: Wed Jun 16, 2010 5:44 am
by ETLJOB
Is there any specific reason for not using sequencers?
1. Two "dsjob" commands from the script.
2. Job schedulers.
Re: Alternate way without using sequencer
Posted: Wed Jun 16, 2010 6:19 am
by Sainath.Srinivasan
sirishds wrote:I have a couple of jobs need to be executed sequentially but i am not supposed to use sequencer is there any alternative way to perform the control flow of jobs..
Is this another interview question ?
Do not know whether it is just me, but your questions appear to point towards specific properties by constraining all general and default options, which is typical of interviews.
Posted: Wed Jun 16, 2010 4:50 pm
by ray.wurlod
It's OK, no question was asked.
Posted: Wed Jun 16, 2010 11:51 pm
by prasad.bodduluri
you can use batch mode to run jobs without sequence
Posted: Thu Jun 17, 2010 12:56 am
by ray.wurlod
A batch IS a sequence, except for having no GUI and a specific naming convention. Similarly a job control routine IS a sequence, except for having no GUI.
Of course the really smart answer is to use a sequence.
A sequence is not a sequencer. A sequencer makes an "any/all" decision about which of its inputs has fired.