The job was the deadlock victim in last two runs. The owner of the job must change the logic so that this doesn’t participate in dead lock again and again which causes failure.
Suggestion: disable nonclustered indexes before rebuilding clustered indexes.
INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.
- SQL Server DBA “Interview Questions And Answers”
- SQL Azure Interview Questions and Answers Part – 1
- SQL Azure Interview Questions and Answers Part – 2
- Powershell Interview Questions and Answers
Online MSSQL Classes @ http://tuitionaffordable.webstarts.com