Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sathiesh2005
Yak Posting Veteran
85 Posts |
 Posted - 2011-03-01 : 04:57:07
|
| Hi,I have a job with multiple steps. These steps will call SP in this i am transferring text/xml files from one folder in current server to another server using ftp mget and mput commands. after copying the file i am deleting the source.My Problem is some times the job hangs in a step. I am killing the job manually in enterprise manager using the process id in all the nodes process info, lock process ID and Lock Objects.Is there any possibility to timeout/kill this job if it runs for a long time? In normal execution it will take approximately 1 minute to complete.Looking for a solution.Thanks.@Sathiesh |
|
|
|
|
|
SQL job timeout or kill