Page 1 of 1
Reg job schedule
Posted: Fri Mar 13, 2009 7:16 am
by muralisankarr
We have 5 jobs (J1, J2, J3, J4, J5)
The completion of J1 depends on the arrival of a file from 3rd party system.
We need to schedule the jobs like
J2 Start Time = J1 Completion time + 10 min
J3 Start Time = J2 Completion time + 40 min
Now is it possible to schedule the jobs (by time) using JCL in Server jobs?
like start time = (n + x) min, Where n = completion of some job
and X = Time added for server availability
Many Thanks
rMS
Posted: Fri Mar 13, 2009 7:22 am
by Sainath.Srinivasan
Make the job "sleep" for that duration.
Posted: Fri Mar 13, 2009 7:37 am
by chulett
In other words, use a Sequence job to control the flow of the jobs and the dependencies between them. To handle the +x minutes delayed start time requirement, add a Routine Activity stage between the jobs that sleeps for the appropriate amount of time.
Posted: Fri Mar 13, 2009 8:28 am
by muralisankarr
chulett wrote:In other words, use a Sequence job to control the flow of the jobs and the dependencies between them. To handle the +x minutes delayed start time requirement, add a Routine Activity stage between the jobs that sleeps for the appropriate amount of time.
We have nearly 300 jobs scheduled for a week. Having a Routine with sleep will made my master job to run for the entire day. Our main objective is from completion of main job, we need to schedule other jobs. We are looking at a robust control mechanism. Please help us with this with your thoughts
Many Thanks
rMS
Posted: Fri Mar 13, 2009 8:38 am
by chulett
Next time, can we start with your
actual requirements? We posted solutions for the problem you posed to us.
You can still use a Sequence job for the 'from completion of main job, we need to schedule other jobs' question, if you want to handle all of the dependancies within the DataStage GUI. If that won't work for you, you'd need to do a better job of explaining why not.
When I see 'robust control mechanism' the first thing that pops into my mind is 'Enterprise Scheduler'. Do you have access to any such thing, say like Control-M or any of the many others out there? Or are we firmly into 'roll yer own' territory?
Posted: Fri Mar 13, 2009 8:39 am
by Sainath.Srinivasan
Your requirement drives the answers. Specifying requirement in refined format and in full will lead to better answers.
You wanted to wait for 30 mins. Now you want to run 300 such jobs within a day => 300 x 30 mins = 9000 mins sleeping time.
Mins in day = 24 * 60 = 1440.
So you will need 6.25 days for each batch to finish (apart from the job run time).