deadlock on scheduled agent jobs in sql2005

• jamessdba

  SSCrazy

  Points: 2256

  More actions

  September 28, 2012 at 7:01 am

  #282318

  HI,

  in one our server we are getting when 2 scheduled jobs failing with below errors

  1)--Executed as user: NT AUTHORITY\SYSTEM. Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205). The step failed.

  2)

  Executed as user: NT AUTHORITY\SYSTEM. Transaction (Process ID 75) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. [SQLSTATE 40001] (Error 1205). The step failed.

  Please suggest the solution

  Thanks in advance

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  September 28, 2012 at 7:20 am

  #1543402

  Check both the processes(code inside job) there must be some code/ logic conflict.

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)