I configured a maintenance plan with 3 steps under a 2008 r2 sql server.
1º check database integrity
2º rebuild index
3º delete old logs
I scheduled the plan to be ran every sunday at 10 pm, but the task crashes. If I open a console and paste the sql commands, everything goes fine.
The database integrity is OK because of this I don´t understand why the plan stops 10 seconds after starting.
maybe a bug?