Solved

SQL server agent job questions?

Posted on 2012-03-28
6
313 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
[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
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:Ramesh Babu Vavilla
Ramesh Babu Vavilla 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
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
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

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

728 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