Schedule job in director every hour without instances

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
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Schedule job in director every hour without instances

Post by vinaymanchinila »

Hi,
I am trying to schedule 8 jobs every hour and is there a workaround of doing this in the DS Director without whole lot of instances filling up the director!
Thanks,
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

You need to create a sequencer or batch control job.

Before that you need to ensure that they will finish within the hour.
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

but these 8 jobs run at different hours like one at every hour starting at 7 , other at 8.30 ...so on!
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Just take each job and 'Add to Schedule' multiple times.
-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 »

Craig's idea is the best if you cannot code batch control and include the timings as parameters.

Otherwise, you can also include them as cron entries.
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

I have just added each job multiple times even though they look like lot of jobs !
Thanks guys.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

I would reuse the instance ids every other hour or every 3 hours then you do not have a lot of instances ids.
Mamu Kim
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

Hi Duke,
Thats a great idea, how do I find the instance id and reuse it?
Thanks,
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What happened to "Schedule job in director every hour without instances"? :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
anupam
Participant
Posts: 172
Joined: Fri Apr 04, 2003 10:51 pm
Location: India

Post by anupam »

You can have 1 additional parameter say InstanceId and that parameter can be reused every 3 hours or every day as the Instance number/ Invocation Id for the Job.

This InstaceId would be passed while running the Job. if you have to run Job 8 times a day, then you may choose say from 1 to 8 as the IntanceId or you can choose the Hour of run as the InstanceId and pass it to Job.

At any point in time the max number of Instances filling the director would be 8.
----------------
Rgds,
Anupam
----------------
The future is not something we enter. The future is something we create.
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

Hey Craig,
Just trying to cut the instances down atleast and we are planning to go for Control-M scheduler!
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

Control-m wouild make this a lot easier.
Mamu Kim
Post Reply