×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Retry DTS Job after 5 minutes

Retry DTS Job after 5 minutes

Retry DTS Job after 5 minutes

(OP)
I am getting a file via FTP, but if the file is old, then I want to retry the job after 5 minutes. I also want to limit the number of repeated attempts to ten.

I thought I'd seen an ActiveX script that would do this, but now I can't find it. Does anyone have a suggestion?

RE: Retry DTS Job after 5 minutes

Have a part of the DTS package log into the database and add a one time job schedule using the sp_add_jobschedule, of if you want to get really fancy, have two schedules.  One to go off at the same time every day, and a second one which you keep disabled.  When the package needs to be restarted enable the disabled schedule, and reset the schedule for 10 minutes later using the sp_update_jobschedule procedure.  If the run time is 100 minutes or greater after the start time of the first job, disable the second schedule instead of reseting the time.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close