TechBubbles Microsoft Technology BLOG

Running SQL Server JOBS with different user accounts in SQL 2008

 

This post discusses about configuring different user account to JOB running in SQL Server 2008. By default SQL JOBs runs under service account that you have configured while installing the SQL Server. You can follow the below steps to change the user account that running under JOB

 

1. Open SQL Server Management Studio and expand the SQL Server Agent node and Select the JOB that you want to change the running account.

image

2. Double click the selected JOB then you will get the below dialogue

image

3. Select the Steps from the above window and click Edit to see the below properties window

image

4. Click the ellipses button right to Run as user and select the user from below window and say ok

image

Now your job will run under chosen user account. It is always recommended to run your SQL JOBS under one account rather putting to many user accounts for to many JOBS. This post is for the people who have the business reason and want to run under different user account.

Share this post :

About the author

Kalyan Bandarupalli

My name is kalyan, I am a software architect and builds the applications using Microsoft .NET technologies. Here I am trying to share what I feel and what I think with whoever comes along wandering to Internet home of mine.I hope that this page and its contents will speak for me and that is the reason I am not going to say anything specially about my self here.

Add Comment

TechBubbles Microsoft Technology BLOG

Follow me

Archives

Tag Cloud