Search code examples
sql-serversql-server-2008ssissql-server-agent

SQL Agent Command Line Not Saved

I have a SSIS package I am trying to schedule. I create a new job under SQL Server Agent. On the Command line tab of the jobstep, I choose "Edit the command-line manually".

The changes are retained as I switch from tab to tab within the job step but whenever I exit and save the job, the changes are lost.

Any ideas what's going on?

I'm on SQL Server 2008.

Solution

  • This is a confirmed bug, but here's a workaround that my team uses:

    1) Script the create job statement (without your edits)

    2) Delete the job from SQL Agent

    3) Perform your edits in the create script

    4) Execute the create job

    This will allow you to keep your manually modified command line options.