Page 1 of 1

DataStage job scheduling problem

Posted: Sun Jan 14, 2007 11:33 pm
by mydsworld
I have a DataStage parallel job to schedule which has the following requirement :

In 4 weeks of a month,

1. It needs to be invoked 1st Satday with parameter A,B
2. Next Satday with C,D
3. Next Satday with E,F
4. Next Satday with G,H

Please advise whether this is possible through DataStage Director. I didn't find any every 'n' th kind of scheduling option.Scheduling with every Satday option creates problem as the parameters are different.

Posted: Sun Jan 14, 2007 11:44 pm
by narasimha
If your question is just is it possible through Datastage Director.
Then it is no.
Is using any external scheduling tools an option for you?

Posted: Sun Jan 14, 2007 11:50 pm
by chulett
Actually, you can but it's not elegant. Do one 'Next Saturday' with the proper parameters and then after it runs, remember to schedule in the next one. Lather, rinse, repeat. Either that or say (this month) the 'Next 6th' then 'Next 13th' then 'Next 20th' (etc) and repeat only once a month.

Better bet is via an Enterprise Scheduler as Narisimha notes, something without the 'limitations' of cron.

Scheduling option

Posted: Mon Jan 15, 2007 12:04 am
by mydsworld
Thanks for your response.

Actually there is a limitation of changing the schedule manually (after every run).So, can you please suggest any external scheduling tool that can be used with DataStage Director to do that kind of scheduling.

Posted: Mon Jan 15, 2007 12:09 am
by chulett
Pretty much any one, actually. What one, if any, does your company use? Leverage the 'dsjob' command line utility to allow it to run your jobs. This executable is quite thoroughly explained in either of the Developer's Guides in the Command Line Interface section near the end.

Posted: Mon Jan 15, 2007 11:31 am
by DSguru2B
Or if this completely falls on your shoulders then you can incorporate this logic is a small script. The script will take the current date and check if its first saturday, second, third or fourth. Depending upon that it will assign the parameters via the dsjob command and run the job. You can also incorporate this functionality in a sequence job that gets executed every saturday. The sequence will have a routine activity stage which will return a value depending upon the week and you can branch your execution to a particular job with the appropriate parameters.