Restartable sequence jobs
Posted: Wed Dec 10, 2008 12:22 am
Hi All ,
We have created certain server jobs for interface say ABC.Those jobs are for extraction, transformation, load. Then we have created certain sequence jobs for extraction, transformation, load where all the severs jobs are added . These seuence jobs are then added in master sequence job of our DataWarehouse.
Currently if any jobs of interface ABC fails we are not able to restart the Interface/seuence jobs.
My querry is we need to make changes to existing sequnece jobs (may be create a new sequnce job) so that they can be restartable.
So what chnages do I need to do to make these sequnce job restartable ?
Thanx in advance ...
We have created certain server jobs for interface say ABC.Those jobs are for extraction, transformation, load. Then we have created certain sequence jobs for extraction, transformation, load where all the severs jobs are added . These seuence jobs are then added in master sequence job of our DataWarehouse.
Currently if any jobs of interface ABC fails we are not able to restart the Interface/seuence jobs.
My querry is we need to make changes to existing sequnece jobs (may be create a new sequnce job) so that they can be restartable.
So what chnages do I need to do to make these sequnce job restartable ?
Thanx in advance ...