Solved

run job as specific acount

Posted on 2011-03-07
7
277 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:Butterfield_Cayman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 4

Accepted Solution

by:
Amgad_Consulting_Co earned 250 total points
ID: 35058815
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
 

Author Comment

by:Butterfield_Cayman
ID: 35058868
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
 
LVL 4

Assisted Solution

by:Amgad_Consulting_Co
Amgad_Consulting_Co earned 250 total points
ID: 35058894
can you try the one on general tab.
0
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 

Author Comment

by:Butterfield_Cayman
ID: 35058931
yep, got that one going - thanks. justr had to create the correct proxy account. thanks for help.
0
 
LVL 4

Expert Comment

by:Amgad_Consulting_Co
ID: 35058935
here is how it looks on my side.

 sample
0
 

Author Comment

by:Butterfield_Cayman
ID: 35058967
i'm using 2005 - is that 2008? interesting
0
 
LVL 4

Expert Comment

by:Amgad_Consulting_Co
ID: 35058985
yes it is SQL 2008
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question