Results 1 to 2 of 2

Thread: Job Scheduler - Fail step after X minutes?

  1. 03-17-2011, 01:26 PM #1
    joshk
    joshk is offline Registered User
    Join Date
    Oct 2003
    Posts
    14

    Job Scheduler - Fail step after X minutes?

    Is there a way in the SQL Server 2005 Job Scheduler to set a job step to fail if it runs for more than a specified length of time? For example, I have an FTP job step that typically takes around 10 seconds. It hung up today because the FTP site it connects to was having technical problems. I had to manually kill the job. I'd like to be able to set that step to automatically fail if it runs for more than two minutes or something similar.
    Reply With Quote Reply With Quote
  2. 03-17-2011, 02:43 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Doesn't have that function, you need kind of monitoring job to do that.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules