Event Based Scheduling + Time Based Scheduling
Moderators: chulett, rschirm, roy
Event Based Scheduling + Time Based Scheduling
Is there any way in DataStage to schedule a job at 9 A.M on every Saturday Weekly and but at the same time it should not get triggered untill another job or Sequencer Finished completely.
Aim high
Re: Event Based Scheduling + Time Based Scheduling
I don't think there is any direct way to schedule like that, but you have a work around :nkln@you wrote:Is there any way in DataStage to schedule a job at 9 A.M on every Saturday Weekly and but at the same time it should not get triggered untill another job or Sequencer Finished completely.
In your first job, create a sequential file using after job routine.
Create a sequence for you second job and use the wait for file activity, which should be waiting for the file that would be created in your first job.
That's what Enterprise Schedulers are for, tools like Control-M would make that simple. It's more complicated to juggle all of that within DataStage. Sun Rays has given you some food for thought on how to create the inter-dependencies you'd need.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers