• No, SQL Server waits ad infinitum for locks to be released. As Gianluca suggested, please use sp_who2 or sp_whoisactive to find out whether there is any blocking. What does the job do - is it a simple T-SQL batch, or does it do anything external, such as backups and restores, SSIS packages and so on?

    John