run job as specific acount

experts,

i have a SQL job queries a database and exports a text file to a specific location. i need to run the jobs under a specific account, so that it has permissions to write to the directory where I'm trying to copy to. This seems like it should be simple, but I can't seem to find a way. on my jop steps, i have a "run as" option, but I can't figure out how to create an account with the needed credentials to populate this drop down.

thanks in advance.
Butterfield_CaymanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Amgad_Consulting_CoConnect With a Mentor Commented:
you can set that in the job step.

get job properties, step , advanced and the set "run as user" value.

check this link http://blogs.msdn.com/b/varun_sharma/archive/2007/08/30/how-to-run-sql-server-agent-and-sql-server-jobs-with-least-privilege-in-sql-server-2005.aspx
0
 
Butterfield_CaymanAuthor Commented:
i don't see a "run as user" value on the advanced tab. I see one on the general tab. looks like creating a proxy may be the way to do this?? not 100% sure though.
0
 
Amgad_Consulting_CoConnect With a Mentor Commented:
can you try the one on general tab.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Butterfield_CaymanAuthor Commented:
yep, got that one going - thanks. justr had to create the correct proxy account. thanks for help.
0
 
Amgad_Consulting_CoCommented:
here is how it looks on my side.

 sample
0
 
Butterfield_CaymanAuthor Commented:
i'm using 2005 - is that 2008? interesting
0
 
Amgad_Consulting_CoCommented:
yes it is SQL 2008
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.