Troubleshooting: A scheduled stored procedure job has been failing

Issue

The scheduled tasks history shows that the scheduled statistics stored procedure has been failing with the following errors:

02/0718: 00:08:38.78 spid17 Row compare failure

02/0718: 00:16:49.00 spid17 Error : 1509,Severity: 20,State: 3

Details

When Error 1509 occurs, it could mean that the data or index has been corrupted. In the previous example, it says that the update statistics job failed.

Solution

By running the store procedure jobs manually, you can identify the damaged index. After the index is identified, you can re-create it.