Thursday, October 18, 2012

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

One of the  maintenance plan has been failing with below error Message.

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


So I started the  investigation what is missed  in the maintenance plan.
I saw that in the job step where the information for the maintenance plan is mentioned the ‘\’ at the beginning of the plan name was missing.
 
The typical plan names are mentioned as
\Maintenance Plans\Full Backups
 
But this time it was mentioned as
Maintenance Plans\Full Backups


So I added the ‘\’ at the beginning of the plan name in the job step after that maintenance plan executed successfully.

Thanks
ASR
 

No comments:

Post a Comment