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?
 
Amgad_Consulting_CoCommented:
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_CoCommented:
can you try the one on general tab.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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.