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
trying to dynamically schedule SEQ jobs in Data Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 24
- Joined: Wed Apr 16, 2014 11:11 am
- Location: United States
-
- Participant
- Posts: 24
- Joined: Wed Apr 16, 2014 11:11 am
- Location: United States
Re: trying to dynamically schedule SEQ jobs in Data Stage
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
Thanks again
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. ![Wink :wink:](./images/smilies/icon_wink.gif)
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 24
- Joined: Wed Apr 16, 2014 11:11 am
- Location: United States
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
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
Thanks. Can you clarify what 'meet the run criteria' means? I could make an assumption but I'd really rather not.ep_datastage wrote:But the SEQ jobs should only run if the date/time values from the control table meet the run criteria.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
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.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"How did you get up there?"
"It wasn't easy!"
-- Big Trouble in Little China
![Cool 8)](./images/smilies/icon_cool.gif)
"It wasn't easy!"
-- Big Trouble in Little China
![Cool 8)](./images/smilies/icon_cool.gif)
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872