Any viable way of how to automatically re-execute the failed package. That
is, to re-execute it three times then exit if failed again?
what steps and what will the code look like???

Thanks


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200508/1

You could have a job that has 3 steps linked by failures. Each step
executes the package. have the package fail on first error which should
fail the step and then it should follow on and execute the package again and
again.

i am curious as to why you do not handle this more gracefully
Also what will change mid execution to make the second or third run through
pass.

Allan

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

I agree. I would create a SQL Agent job that retries the failed package a
number of times. We use this system to process files automatically from our
FTP servers. (Our clients are usually late with their files.)

Here's how I do it:

- From Enterprise Manager
- Right-click DTS package, choose "Schedule Package..."
- Pick a time, you can edit this later, OK
- Navigate to 'Management / SQL Server Agent / Jobs'

- Find your newly created Job
- Right-click "properties"
- Click "Steps" tab
- Edit
- Advanced Tab
- Set Retry Attempts & Retry Interval
- OK, OK .. etc

Tom


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200508/1