SSIS Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

frankc2@comcast.net - 25 Mar 2008 21:21 GMT

I need to run a SQL Task If the task fails I want it to wait for 10
minutes then I want it to retry the task until it succeeds. So to go
into more detail I have a task that checks to see if data is being
loaded into the database if it is I want to wait until it is done
before I run maintenances. So I would like to have the task set to
fail if there is data loading and set to move on through the job if
data is not loading. If the task fails however I would like it to wait
for 10 minutes then try agian until it succeeds.

Anyone have any ideas...

Thanks
Chris

Reply to this Message

John Bell - 27 Mar 2008 08:55 GMT

Hi Chris

You may want to try microsoft.public.sqlserver.integrationsvcs for SSIS
posts! Rather than having the package to run continually and wait I would
schedule a job that ran every 10 minutes and the first step could be the
check for data which would exit if no data was present. There are various
ways to do this the simplest may be to do something like

IF NOT EXISTS ( SELECT ... )
RAISERROR(... )

in an Execute SQL task.

Doing it that way would allow you to run adhoc jobs and change the job
schedule without having to change the package.

John

> I need to run a SQL Task If the task fails I want it to wait for 10
> minutes then I want it to retry the task until it succeeds. So to go
[quoted text clipped - 9 lines]
> Thanks
> Chris

Reply to this Message