SSIS package SQL job not using new environment var

问题:

When I set up my Production SQL job to execute my SSIS package which use an environment variable for configuration, the job does not use the Production config value of the environment variable on the production server. The job use the design time values instead. I created the environment variable on the same server that I exec the job (Production). Any thought?

回答1:

I figured out that I have to restart the SQL Server Agent in order for the SQL Agent to recognize the newly created Environement Variable.