Maintenance Plan Job Failed
Nuestro buen amigo Alberto Morillo Rodriguez nos comparte su artículo:
Applies to: Microsoft SQL Server 2005 Developer Edition SP4.
Problem Description.
We had a maintenance plan running successfully on a server for months, and all of a sudden it started to fail. The maintenance plan was created to schedule a rebuild of indexes and update statistics.
On examining the history of the maintenance plan job, we found it failed while rebuilding indexes as shown below.
The job outcome was the following:
Date 4/10/2012 10:51:21 AM
Log Job History (MaintenancePlan - Monday.Monday)
Step ID 0
Server SERVERDB
Job Name MaintenancePlan - Monday.Monday
Step Name (Job outcome)
Duration 00:05:34
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Ver más aquí.
Saludos.
Fernando García Loera (Community Program Manager – Latin America Region)