Failed Package

#1

Can someone help with a code that will automatically re-execute a failed
package.., try to re-execute it three (3)times, then exit if failed after
the third time.

Thanks

--
Message posted via http://www.sqlmonster.com

#2

Use a SQL Agent job, and the step retry count.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"richard s via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Quote:

Can someone help with a code that will automatically re-execute a failed
package.., try to re-execute it three (3)times, then exit if failed after
the third time.

Thanks

--
Message posted via http://www.sqlmonster.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Failed Package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Failed Package - 08-19-2005 , 09:08 AM

Re: Failed Package - 08-19-2005 , 09:56 AM