Hi,
Can anyone tell what are the disadvantages of using a job sequencer..
Actually we have the scheduling tool, so i am planning to have separate ETL jobs called from the scheduling tool..but we can have one job sequencer to call all the jobs and execute..I feel restartability is little complex using job sequencer..
disadvantages of using job sequencer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What's your alternative that you believe not to be as complex as a sequence job?
(The terminology is "sequence" - a "sequencer" is something you use IN a sequence job.)
(The terminology is "sequence" - a "sequencer" is something you use IN a sequence job.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
You are in for a world of hurt if you plan on having your Enterprise scheduling tool running hundreds or thousands of individual jobs, enforcing dependencies, error handling, restarts and the like.
If you've got nothing else, there is no disadvantage to sequence jobs and their restartability can be as simple or as complex as you want to make it. Now, if you are running a version of 7.x earlier than say 7.5 I may need to revise that answer.
And for Ray, while we love to nit-pick on the 'sequence job' versus 'sequencer stage in a sequence job' subject, you do need to recognize that the official documentation names them as equal part sequence, sequence job, job sequence and job sequencer. From the 8.1 docs:
"WebSphere DataStage provides a graphical Job Sequencer which allows you to specify a sequence of parallel jobs or server jobs to run."
I tend to cut people more slack on that unless their usage is actually confusing.
If you've got nothing else, there is no disadvantage to sequence jobs and their restartability can be as simple or as complex as you want to make it. Now, if you are running a version of 7.x earlier than say 7.5 I may need to revise that answer.
And for Ray, while we love to nit-pick on the 'sequence job' versus 'sequencer stage in a sequence job' subject, you do need to recognize that the official documentation names them as equal part sequence, sequence job, job sequence and job sequencer. From the 8.1 docs:
"WebSphere DataStage provides a graphical Job Sequencer which allows you to specify a sequence of parallel jobs or server jobs to run."
I tend to cut people more slack on that unless their usage is actually confusing.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's OK, I spread the joy. I do harangue IBM about errors in their manuals. They claim to welcome the feedback. Sometimes the changes even make it into the next edition!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.