SSIS包SQL作业不使用新的环境变量配置
问题描述：
当我设置生产SQL作业以执行使用环境变量进行配置的SSIS包时，作业不会在生产服务器上使用环境变量的生产配置值。
工作使用设计时间值。
我在执行作业（生产）的同一台服务器上创建了环境变量。任何想法？
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?
答
我想到我必须重新启动SQL Server代理才能使SQL代理识别新创建环境变量。
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.