Hi All,
I'm using a very simple job sequence wherein 5 jobs where used. I'm getting an error in the 4th job in the sequence. Is there a way to specify so that once I fix the issue, I can restart the job from the 4th job. Meaning: Is there a way to restart the job from where it stopped instead of starting it all over again, once the error has been fixed?
Thanks,
Vicky
JOb Sequencer Error
Moderators: chulett, rschirm, roy
Welcome! :D
Which version of 7.x do you have? From (I believe) 7.1 forward, there is an option on the Job Properties tab of Sequencers to add restart checkpoints. It will give you the ability to do what you want 'automagically' without all the goofy coding needed in earlier versions.
Make sure you read the documentation for that feature so that you understand how it works and under what circumstances it doesn't work.
Which version of 7.x do you have? From (I believe) 7.1 forward, there is an option on the Job Properties tab of Sequencers to add restart checkpoints. It will give you the ability to do what you want 'automagically' without all the goofy coding needed in earlier versions.
![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
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
At version 6, you have two options:
1) copy the sequencer and delete the first three JobActivity stages
2) Recode the sequencer
2.1) Add a job parameter, StartingJobNum, (integer) that is your starting job number (1,2,3,...).
2.1) Placing a Sequencer stage between each JobActivity stage, and before the first JobActivity stage. Set their mode to Any.
2.2) Next, add a NestedCondition stage to each Sequencer stage. Each Sequencer stage now has and input from its NestedCondition stage and from the preceding JobActivity stage. Of course, the first Sequencer only has a NestedCondition input.
2.3) In the first NestedCondition stage, set the condition to. In the second NestedCondition stage, set the condition to . In the third NestedCondition stage, set the condition to . Repeat this series until you run out of sequencer stages.
2.4) Now run the job sequencer setting the value of the StartingJobNum parameter to 4.
1) copy the sequencer and delete the first three JobActivity stages
2) Recode the sequencer
2.1) Add a job parameter, StartingJobNum, (integer) that is your starting job number (1,2,3,...).
2.1) Placing a Sequencer stage between each JobActivity stage, and before the first JobActivity stage. Set their mode to Any.
2.2) Next, add a NestedCondition stage to each Sequencer stage. Each Sequencer stage now has and input from its NestedCondition stage and from the preceding JobActivity stage. Of course, the first Sequencer only has a NestedCondition input.
2.3) In the first NestedCondition stage, set the condition to
Code: Select all
StartingJobNum = 1
Code: Select all
StartingJobNum = 2
Code: Select all
StartingJobNum = 3
2.4) Now run the job sequencer setting the value of the StartingJobNum parameter to 4.
Chuck Smith
www.anotheritco.com
www.anotheritco.com
Pls check this Error
Hi I am getting this Error while running a server Job
Attempting to Cleanup after ABORT raised in stage BGTOUT1..Transformer_1
Job design : one ORACLE OCI stage as source stage and ODBC stage as reference INPUT , one TRANFORMER Stage and Target stage as Oracle.
In Transformer I am multiplying two fields. Up to 726 Records it is running fine, but at 727 record Job getting aborted and I am getting above Error.
Pls help me.
Thanks
Attempting to Cleanup after ABORT raised in stage BGTOUT1..Transformer_1
Job design : one ORACLE OCI stage as source stage and ODBC stage as reference INPUT , one TRANFORMER Stage and Target stage as Oracle.
In Transformer I am multiplying two fields. Up to 726 Records it is running fine, but at 727 record Job getting aborted and I am getting above Error.
Pls help me.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard! :D
Can you please post this as a new topic? It's not related to job sequences. Posting as a reply to this thread makes it difficult for future searches. We'll answer it as soon as the new topic appears.
You might also profitably use the comprehensive Search capability of the forum (find Search on the menu bar at the top of your screen). Search for some of the words in your error message. It HAS been seen before.
Can you please post this as a new topic? It's not related to job sequences. Posting as a reply to this thread makes it difficult for future searches. We'll answer it as soon as the new topic appears.
You might also profitably use the comprehensive Search capability of the forum (find Search on the menu bar at the top of your screen). Search for some of the words in your error message. It HAS been seen before.
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.