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.
