Page 1 of 1
CHECKPOINT concept
Posted: Thu Apr 13, 2006 3:41 pm
by chandra
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]
Posted: Thu Apr 13, 2006 3:42 pm
by kcbland
Why do the last 3 posts from you in the space of 5 minutes look like job interview questions?
Posted: Thu Apr 13, 2006 4:26 pm
by ray.wurlod
Do you mean Job or Job Sequence ?
Posted: Thu Apr 13, 2006 7:53 pm
by chandra
jod sequencer is not my point
Posted: Thu Apr 13, 2006 8:19 pm
by chandra
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...
i want ti know is the option avalible in JOB.
Posted: Thu Apr 13, 2006 8:44 pm
by chulett
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...
Um... no. If you restart the sequence it will 'skip up to' the failed
job and restart the
sequence from failed
job.
chandra also wrote:i want ti know is the option avalible in JOB.
No, not as an option. That doesn't mean you can't code it in yourself, however.
Posted: Thu Apr 13, 2006 9:14 pm
by kcbland
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.
Posted: Fri Apr 14, 2006 12:02 am
by ray.wurlod
chandra wrote:jod sequencer is not my point
Neither server nor parallel jobs have checkpointing capability, unless you design it in yourself.