Thursday, October 14, 2010

Unable to start execution of step 1

On SQL 2005, I created a simple database and log file backup job using the Maintenance Plan wizard and scheduled it, but it does not work. When I run it, it generates an error:

"Unable to start execution of step 1 (reason: line(1): Syntax error). The step failed."

I can't believe MS would have this kind of bug. Something generated by a wizard needs to work. PERIOD.

Anyway, the fix for me was this:

1. Go to SQL Server Agents\Jobs. Select job and click Properties.
2. Go down to Steps
3. Highlight your SubPlan and click Edit
4. Add a Backslash to the beginning of the path listed in the "Package" box

And, like magic, no error and job runs.

Hope that helps!

No comments:

Post a Comment