Post reply

Unable to start execution of step 1

  • April 15, 2008 at 10:09 am

    #379811

    I'm trying to create a backup plan and when I run it, I get the error:

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

    This is a simple backup database to file every tuesday and thursday plan. Using sa authentication.

    Anyone have an idea?

  • April 15, 2008 at 10:36 am

    #802687

    Line 1:

    EXECUTE master.dbo.xp_create_subdir N'C:\SQL Server Backups\test'

    If I run the t-sql manually it works (From New Query).

  • April 15, 2008 at 12:25 pm

    #802742

    Also note, this is running on vmware, so I don't know if this would affect it.

  • April 15, 2008 at 12:57 pm

    #802756

    I tried configuring the user for sql service service and sql server agent service as administrator but still not working.

    I have this procedure working on my physical machine.

  • April 15, 2008 at 2:03 pm

    #802788

    Problem fixed by applying SP2.

  • October 29, 2008 at 3:03 am

    #891076

    SP2 is already installed and in my case the problem occurred 'out of the blue'.

  • July 31, 2009 at 1:01 am

    #1032798

    Try 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

    Thanks,

    Rupashri

  • August 18, 2010 at 3:35 am

    #1208370

    Thanks Rupashri this worked for me.

    This was driving me mad :w00t:

  • September 14, 2010 at 9:45 am

    #1220786

    Hi,

    I had exactly the same problem - this just started occurring for no real reason. I added the \ to the start of the package as suggested and it has fixed the problem - many thanks !

    My question though is - do you know why this has occurred - and how adding the \ has managed to fix the problem ?

    Thanks once again.

  • October 20, 2010 at 11:40 am

    #1239843

    Hi,

    Please let me know,how adding the \ Backslash to the beginning of the path listed in the "Package" box is fixing the issue.

    Thanks,

    Deepak

  • October 21, 2010 at 6:28 pm

    #1240666

    Thanks its working!!!!!

  • November 2, 2010 at 8:21 am

    #1245414

    This post was very helpful for me as well, thanks very much for posting this solution !!

    FYI - Am using SQL 2005 base ver. 9.0.1399

  • November 9, 2010 at 2:58 pm

    #1248611

    Yet another reason I like this site. Worked for me also!!!

  • May 23, 2011 at 2:26 am

    #1328337

    Hi, I applied the same method of adding a backslash on the path and it worked when i ran it manually...it was suppose to run at 12am as scheduled the following morning but it failed, what could be the problem?

  • June 13, 2011 at 7:32 am

    #1337737

    Thanks for this, working great for me.

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply