Nuestro buen amigo Alberto Morillo Rodriguez nos comparte su artículo:
Maintenance Plan Job Failed
Applies to: Microsoft SQL Server 2005 Developer Edition SP4.
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)
Que es un MVP? / Tips para ser MVP