Hello,

I have scheduled a job using Job Agent in SQL2K (Management). Every once in a while i get an error when i view job history:

Executed as user: xxx. Transaction (Process ID 53) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205). The step failed.

The process ID changes for every error. Sometimes its 51, 56, or 54 as well.

I have checked several times, but there is no other process that runs at that time. I even rescheduled it for a different time, but even then it fails about once every week or two.

How can i check what is the other procedure it is deadlocking with, if it is? OR what exactly is the problem, if it is not with any other process?

Any help and/or guidance is much appreciated.

Thanks,

J