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.

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.

There is a bug with the Set Values properties in SQL Server Agent for SSIS packages. You need to save the job step while still on the tab I think(?). I'll see if I can remember and reproduce the steps, but you're not going crazy. ;)

You may need to click "OK" for the job step, and "OK" for the job before moving on to any other changes in the job.

try a copy save as on the package and save change the protection level to encrypt sensitive data with password

I had the same issue when trying to append /DumpOnError to the command line tab of the only step in a job. What I realized was that the change was really performed. And I found it out by generating the "create job" script. What was happening then? Well, it seems as if in the edit box of the command line tab you always got the "default" configuration, however the real one is. I checked it on three installations. 2008 standard, 2012 enterprise and 2017 enterprise.