Sunday, March 2, 2014

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

This morning I worked with one of the customers on configuring the database backups, and stuck with an issue that after finalizing the Maintenance Plan the job been generating an error, getting into the job history I have seen the below dumb message:

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

Luckily I found the below articles about this subject and it helped:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/dc52e0d9-af14-46b9-9904-29b9afa798cd/syntax-error-executing-maintenance-plan-job?forum=sqldatabaseengine

http://www.sqlserver-expert.com/2011/08/unable-to-start-execution-of-step-1.html

I found few difficulties while looking into the “package” mentioned in the resolution and therefore I though I would share a screenshot, adding a slash “\” to the beginning of the text worked like a charm:

image


Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo

No comments:

Related Posts:

Related Posts with Thumbnails