SQL Agent Server Job - Job Step Properties - Configuration Tab; why does it take so long to populate the Parameters, Connection Managers and Advanced Tab data?
When editing the Job Step Properties in Management Studio, For my SSIS packages, I often go to the Configuration tab to ensure the Parameters are set for the Environments that I am using. However, I often have to wait a considerable amount of time to see the value populated for each of the sub-Tabs (Parameters, Connection Managers, Advanced). Is there something that can be done to speed up the population of these 3 tabs before I can review, edit and make any changes? Really a time waster and seems I do not understand the underlying reason why there is such a delay in populating these tabs? Any help and guidance to speed up the population of these tabs would be appreciated. ![alt text] : /storage/temp/4608-sql-agent-job-step-properties-image.png