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!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment