SQL Maintenance Plan won’t start
After creating a Maintenance Plan in SQL 2008 to create a backup or something. You’ll notice it hasn’t run by schedule. But if you copy the T-SQL and execute it as an query it qorks fine.
When you take a look at the application event log, you will see an event id: 208 on the SQLAgent$EXACTSQL source.
“SQL Server Scheduled Job ‘MaintenancePlan.Subplan_1’ (number) – Status: Failed – Invoked on: time – Message: The job failed. The Job was invoked by Schedule 9 (MaintenancePlan.Subplan_1). The last step to run was step 1 (Subplan_1).”
Solution: You have to install SQL 2008 Integration Services.
Another thing which can cause a problem is when the SQL ServerAgent service isn’t started or started with wrong credentials, make sure it’s started with user credentials that has access.
