trying to dynamically schedule SEQ jobs in Data Stage

ep_datastage · Post by **ep_datastage** » Mon Dec 14, 2015 10:19 am

Hi, I am new to DS and trying to dynamically schedule SEQ jobs in DS based upon values on a DB2 table. Can I do that and how do I accomplish that?

Thanks again

chulett · Post by **chulett** » Mon Dec 14, 2015 10:29 am

There's no such thing out of the box but that doesn't mean you couldn't cobble something together. What kind of 'values' are in this table?

ep_datastage · Post by **ep_datastage** » Mon Dec 14, 2015 11:17 am

The values will determine which SEQ job will be scheduled and run. So based upon the value I would like to have a particular DS SEQ job run.

Thanks again

chulett · Post by **chulett** » Mon Dec 14, 2015 11:26 am

Was hoping for something more... detailed. So the 'values' are job names? Is there more to it than that, like a time to run it or is that literally all that is in the file? The more details you provide, the quicker we can get to an actual answer / solution.

ep_datastage · Post by **ep_datastage** » Mon Dec 14, 2015 11:52 am

Sorry,

Yes the values will include the job name, as well as the time it should run. That should be all that is needed. Currently I have 3 SEQ jobs that need to run based upon the values on this control table. But the SEQ jobs should only run if the date/time values from the control table meet the run criteria.

Let me know if you need more details.

Thanks again

chulett · Post by **chulett** » Mon Dec 14, 2015 12:14 pm

ep_datastage wrote:But the SEQ jobs should only run if the date/time values from the control table meet the run criteria.

Thanks. Can you clarify what 'meet the run criteria' means? I could make an assumption but I'd really rather not.

FranklinE · Post by **FranklinE** » Mon Dec 14, 2015 1:05 pm

Based on the brief description, what you are asking for is what is provided by scheduling software. We use Control-M, but there are others available.

Control-M provides all that you ask and more, except that the final interface to DataStage is what you provide. We use a Unix script that accepts parameters from Control-M, builds a command line and invokes DataStage with it.

I suggest you investigate these scheduling products before spending the time trying to create one yourself.

chulett · Post by **chulett** » Mon Dec 14, 2015 2:11 pm

We just went through an acquisition of Control-M, you'd have to be willing to pay a goodly amount for the "and more" part.

FranklinE · Post by **FranklinE** » Mon Dec 14, 2015 2:19 pm

"How did you get up there?"

"It wasn't easy!"

-- Big Trouble in Little China

DSXchange

trying to dynamically schedule SEQ jobs in Data Stage

trying to dynamically schedule SEQ jobs in Data Stage

Re: trying to dynamically schedule SEQ jobs in Data Stage