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