Home » Blog » SQL Server 2005 & 2008 – Unable to start job (reason: syntax error)

SQL Server 2005 & 2008 – Unable to start job (reason: syntax error)

Error Message

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

The Problem

SQL renames or re-saves the package job after editing causing the package location to be inaccessible.

The Solution

Append a backslash ‘\’ to the package name

1. Navigate to your job  (Database Server – >SQL Server Agent -> Jobs -> Your Job) and right click, choose properties

2. Click on steps in the job properties, choose the first step in the job step list, click edit below the job list.

3. Add a backslash ‘\’ to the package name and save

HAPPY CODING!

Leave a Reply