Executed as user: WTCEbw.Admin. Transaction (Process ID 95) 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.
这是说明job执行的时候产生了死锁，我们可以使用DBCC TRACEON(1222,-1)命令来抓取死锁信息，死锁每次发生，会记录到ERROR LOG中，ERROR LOG文件存放在.. MSSQL11.MSSQLSERVERMSSQLLog 该目录下。
关闭该跟踪标记，可执行DBCC TRACEOFF(1222,-1)