Job was deadlocked once, so yes, locks are involved, but i didn't investigate it....

I use job executing stored procedures to get data for OLAP. All works fine except one thing: one of the procedures takes a few hours to complete. Executing procedure via remote desktop and query analyzer directly on the server gives the same behaviour.

Same procedure executed from query analyzer/management studio from PC works fine - executes in about five minutes.

SQL server 2k. SP has set nocount, estimated execution...