Suppose i hv developed a JOB which consists of 5 compontents , after executing 3 components the job fails , when next time i start a job it should start from component 3.
how to do that ( i compared the concept with ab initio checkpoint)..
tnxs in adv
[/b]
CHECKPOINT concept
Moderators: chulett, rschirm, roy
CHECKPOINT concept
chandra ,
Hyd
Hyd
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Um... no. If you restart the sequence it will 'skip up to' the failed job and restart the sequence from failed job.chandra wrote:By specifying Checkpointing in job sequence properties, if we restart the job. Then job will start by skipping upto the failed record.this option is available in 7.5 edition...
No, not as an option. That doesn't mean you can't code it in yourself, however.chandra also wrote:i want ti know is the option avalible in JOB.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
If your job has an open cursor with a selection set using a rollback segment and the job fails, the process ends, and the rollback+selection set are released, how could you possible re-enter processing exactly where you aborted when the selection set in the rollback has been released?
You program in your restartability in the way you architect your ETL application.
You program in your restartability in the way you architect your ETL application.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: