Am not a SQL person, but am tryin to learn and write scripts This is my scenario: A bunch of files get FTPd into "server A" at a certain time. These file names are alpha numeric and to understand the names, an application is used. This application links to a SQL DB that helps understand the file nam...

I am with you on this superwesman. Yes it is not the right use the resources until or unless we know the exact resource utilization by the particular job. I would think that having a sys admin rerun the process in a test environment to capture an approx value and then defining the quatitative resour...

IMO, it would be sensible to make it run only for the stipulated time and not exceed it..
killing doesn't make sense.. or is there a reason why you are looking at killing it ?