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.

Posted in Blog, SQL 2008 by ronnypot at October 18th, 2010.

Leave a Reply

Sharing Buttons by Linksku