Event Based Scheduling + Time Based Scheduling

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
nkln@you
Premium Member
Premium Member
Posts: 271
Joined: Wed Nov 17, 2004 5:15 am
Location: US

Event Based Scheduling + Time Based Scheduling

Post by nkln@you »

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
sun rays
Charter Member
Charter Member
Posts: 57
Joined: Wed Jun 08, 2005 3:35 pm
Location: Denver, CO

Re: Event Based Scheduling + Time Based Scheduling

Post by sun rays »

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.
I don't think there is any direct way to schedule like that, but you have a work around :
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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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
Post Reply