-
Title
Error: "Unable to start execution of step 1 (reason: line(1): Syntax error). The step failed" -
Description
Litespeed Maintenance Plan (MP) failing with error "Unable to start execution of step 1 (reason: line(1): Syntax error). The step failed".
Dropping and recreating MP or reinstalling Litespeed doesn't help.
-
Cause
SQL bug, though not clearly documented. Refer to the below links for similar issues.
http://social.msdn.microsoft.com/Forums/en-IE/sqlintegrationservices/thread/d1831274-fbe9-4bb1-bfcb-059ef79a461c
http://sweetsql.blogspot.co.uk/2010/01/ssis-package-fails-from-sql-agent.html -
Resolution
In Sql Server Management Studio (SSMS), under SQL Server Agent -> Jobs, expand the job folder. Right click on the job for the MP failing and select properties. Select the Steps tab and click Edit. In Job Step Properties - Subplan dialog, add a slash(\) infront of the Package: name and click Ok | Ok to save and exit. See attachment.
-
Attachments