To add to that, it depends on the timeout. For example, a lock timeout:
Definately will fail the step (and thus the job).
I did this by trying to update the same record via a proc called from the job step as I had in a hanging transaction in another query window.
- Craig Farrell
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA