-
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.
-
Doesn't have that function, you need kind of monitoring job to do that.
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
|
|