-
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.
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
|
|