[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • Last Modified:

SQL server agent job questions?

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
wasabi3689
Asked:
wasabi3689
5 Solutions
 
AmmarRCommented:
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
 
Ramesh Babu VavillaCommented:
you can
right clck on the jobs,
properties-.owner column, and this isdone
0
 
vdr1620Commented:
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
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
Anthony PerkinsCommented:
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
 
wasabi3689Author Commented:
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
 
AmmarRCommented:
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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