Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 236
Greg Avatar asked Dec 27 '25 16:12

Greg


1 Answers

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.

like image 182
Reagan Williams Avatar answered Dec 31 '25 07:12

Reagan Williams