SQL Job stuck in loop

Networking/Security Forums -> Databases

Author: MadCowLocation: Toronto PostPosted: Mon Sep 24, 2007 2:58 pm    Post subject: SQL Job stuck in loop
    ----
Running SQL2005 and created a job will pulls a file from an FTP server. The job will succeed if there is a file. If there is no file and the job runs it will never stop.

How can I tell it that if there is no file stop after let's say 5 minutes?

Advise Please.

Thank you



Networking/Security Forums -> Databases


output generated using printer-friendly topic mod, All times are GMT + 2 Hours

Page 1 of 1

Powered by phpBB 2.0.x © 2001 phpBB Group