We have a Maintenance Plan (MP) job that rebuilds indexes every week.
The last time, the job failed because of a deadlock. Should I rerun the whole job, or do I just need to rerun the rebuild of the deadlocked index?
The rebuilding of indexes is being performed using standard tools of MP plan.
As I understand it, if a standard MP job for index rebuild stopped because of deadlock, it means that other indexes (after the deadlocked index) also need to rebuild? Or MP job will rebuild all indexes except this one that failed?
Here is example of entry from job history:
Progress: 2017-09-30 21:00:33.06
Source: Rebuild Index Task
Executing query "USE  ".: 0% complete
The package execution fa...
The step failed.
There is no information about which index rebuilds completed, only information that a query started to execute. Looks like one way to check what was rebuilt or not is to check index fragmentation for whole database using T-SQL scripts?
There is only information about deadlock and nothing more in MP log.