Reg job schedule

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
muralisankarr
Premium Member
Premium Member
Posts: 83
Joined: Tue Oct 28, 2008 1:55 am
Location: Chennai

Reg job schedule

Post 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
The minute you start talking about what you're going to do if you lose, you have lost
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Make the job "sleep" for that duration.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
muralisankarr
Premium Member
Premium Member
Posts: 83
Joined: Tue Oct 28, 2008 1:55 am
Location: Chennai

Post 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
The minute you start talking about what you're going to do if you lose, you have lost
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

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