Solved

SQL server agent job questions?

Posted on 2012-03-28
6
303 Views
Last Modified: 2012-04-21
We are using MS SQL 2008 R2

Can we assign other users to run the jobs in SQL server agent? how to do that?

By default, the MS SQL server creates default user to SQL server service? what is it?
0
Comment
Question by:wasabi3689
6 Comments
 
LVL 15

Accepted Solution

by:
AmmarR earned 48 total points
ID: 37781251
hi

sure you can, but you need to make sure the account has the necessary rights and if you are in a domain, it should be a domain user with the necessary rights

check the image attached
Service-account.png
0
 
LVL 10

Assisted Solution

by:sqlservr
sqlservr earned 24 total points
ID: 37781398
you can
right clck on the jobs,
properties-.owner column, and this isdone
0
 
LVL 16

Assisted Solution

by:vdr1620
vdr1620 earned 24 total points
ID: 37783665
basically the user needs permissions to sp_start_job

check this link for details Roles and permissions to run the SQL job
http://msdn.microsoft.com/en-us/library/ms188283%28SQL.90%29.aspx
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 24 total points
ID: 37785168
By default, the MS SQL server creates default user to SQL server service? what is it?
As you can see there is some confusion here. Are you talking about the startup account for the SQL Server Agent service?
0
 

Author Comment

by:wasabi3689
ID: 37787898
Actually I want to the the startup, it seems to me the MS SQL by default to set "Network Service" account to run the SQL agent service, correct?

Second, I want to know if we can assign an user or a group to run the particular job.
0
 
LVL 15

Assisted Solution

by:AmmarR
AmmarR earned 48 total points
ID: 37810173
Dear wasabi3689

check out this article

Server Configuration - Service Accounts

http://msdn.microsoft.com/en-us/library/cc281953.aspx

it mentions that "There is no default logon account for this service.(Sql agent)"

Second sorry i didnt understand What do you mean by

" I want to know if we can assign an user or a group to run the particular job"

jobs run by your sql agent service, and they have the access of the account that is assigned to this service.

you have a job owner but not a specific permission for a group or a user
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

932 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now