I created several packages on DEVSERVER and migrated files to PRODSERVER. I created a job on DEVSERVER and then modified the job script to create the same job on PRODSERVER. When I schedule the job on PRODSERVER it seems that there is some connection to the DEVSERVER that is using up its resources. Shouldn't the sqlsvr.exe process be running on the PRODSERVER? I DID schedule the PROD job from SQL Management Console on the DEVSERVER. Does that have something to do with it? The PRODSERVER does not have the Management Console on it so I cannot create or schedule the job directly from the PRODSERVER. Do I need to do this in order to leave the DEVSERVER out of it completely? ANY input would be greatly appreciated. Thanks in advance. -bitt
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.