Hi all,
I have a sequence, in which i m calling 5 jobs.
In first job data is extracted from oracle db (oracle stage) and loaded into db2table(db2 api stage).If zero rows are transferred,then i want this job to be abort,so that my sequencer is aborted........please adivce me how to implement this..??
Thanks
Sequecer abort issue
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You don't ever want to abort if you can avoid it. Create a simple server job that retrieves the row and loads the same into its user status area then check this in the job sequence to make the decision about whether to process the remaining jobs or merely to bypass them (maybe logging a message and/or sending an email).
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.