Run DTS scheduled job as another user

[angelshark]

Hello,


I have a DTS package that is scheduled to run periodically but it must be run as a user which has rights to a network share.
How do I change the default user that runs scheduled jobs?

Thanks for your help.

 

[ClaireHCM]

You need to change the SQL Agent service account running as the user that you want to.

 

[LFCfan]

i think changing the job owner would be sufficient, if there's only a couple of jobs. you can set it through enterprise manager in the job properties, but there's bound to be a system stored proc you can run as well (i'm not in the office at the moment, so can' t check) should you need to run it programmatically

HTH

 

[angelshark]

Hi guys!

ClaireHsu's suggestion works perfectly. I still have to try changing the job owner as suggested by Ifcfan.

Thanks for answering.

Cheers.