February 11, 2010 at 8:24 am
Hi all, i've a problem.
I'm trying to create an automatic task, i mean, i've a Main DTS, that includes others DTS, when an error occoures i would like to allow a user to fix the problem, then restart the execution a "step" before the problem was occoured, i would like to do that 'cause i have something like 100 jobs planned, and when a job fails i have to press with the right button of the mouse on that job and then launch all the jobs manually...it's pretty boring and not useful...please help me..
February 11, 2010 at 9:27 am
Sorry, I'm not clear what your question is. Do you want to be able to restart a job at a particular step or do you want to restart a package at a particular checkpoint? If the latter, are these DTS packages or SSIS packages? Checkpoints aren't available in DTS.
Greg
February 11, 2010 at 9:37 am
As Greg mentioned, there is nothing like DTS in SQL 2005, it is replaced by SSIS.
You also mention that there are 100 jobs, are those 100 jobs all running SSIS packages?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 11, 2010 at 10:39 am
I agree with the others I am confused about the DTS thing and you can ignore this if you are still using DTS. In SSIS you can execute packages from a master package. As a result of each package running under the master package you could choose to send a notification email of success or failure. In the failure email you could include code to a program that would restart the SSIS package for the task that was failed. There would be issues of security and others that would need to be addressed. Additionally, this would only work well if you choose the file system method of storage.
I don't know if this help by is a general approach you could take.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply