• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 783
  • Last Modified:

service account for running sql agent jobs

Hi,

Can you please advise how i can run sql jobs under an account other than the
account under which sql agent service is running and what privledges should i need to assign to it.
0
Sonali P
Asked:
Sonali P
1 Solution
 
Jared_SCommented:
1) Set up credentialing with the credentials of the user you would like to use.
2) Set up a Proxy for the SQL Server Agent
3) If this is a job, select "run as"... the proxy account for the job step
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now