Tuesday, 15 July 2014

Syntax error executing Maintenance Plan job

Under SQL Server 2005 when attempting to start a Job created by a maintenance plan you may experience the following error

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

Solution is as follows

  • Right click the MaintenancePlan under SQL Server Agents\Jobs and click Properties.
  • Go down to Steps
  • Highlight your SubPlan and click Edit
  • Add a Backslash to the beginning of the path listed in the "Package" box
  • No comments:

    Post a Comment