×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Job on Prod Server using Dev Server resources after migrating packages

Job on Prod Server using Dev Server resources after migrating packages

Job on Prod Server using Dev Server resources after migrating packages

(OP)
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

RE: Job on Prod Server using Dev Server resources after migrating packages

Are you sure you didn't hard code your connections in the SSIS package to your DEVSERVER.  They shoud be soft coded using Config files.

RE: Job on Prod Server using Dev Server resources after migrating packages

(OP)
Thanks for your response.  I have checked all, I mean all of the connections in all of the packages and they all point to the PRODSERVER databases.  Do you think I should install the SQL Management Studio on the PRODSERVER and create the job and schedule from there?  thanks so much.

RE: Job on Prod Server using Dev Server resources after migrating packages

So if I understand you correctly, you have your production server registered on your development machine but are scheduling the Sql Server agent job on the production server not the development server?  If this is true, it shouldn't matter as long as didn't leave the "Server" property for the job as "(Local)" or the Development server name.  

Did you use the "Script Job As" option from the job to create a script file to load it to the production server?

RE: Job on Prod Server using Dev Server resources after migrating packages

(OP)
Gradly, thanks so much for your replies, I will re-script the job as you suggest and see if it changes the behavior.  I initially scripted the job to a "New Query window" and changed all of the instances of DEVSERVER to PRODSERVER.  I thought that would work.  I will let you knwo how it goes.  Thanks again!  -bitt

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

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.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close