[Last Call] Learn how to a build a cloud-first strategyRegister Now


SQL Server 2008 Role to Submit Jobs

Posted on 2011-10-06
Medium Priority
Last Modified: 2012-08-13
I need to allow a user the ability to submit and schedule jobs in SQL Server 2008 R2.

http://msdn.microsoft.com/en-us/library/ms188283.aspx  This artricle seems to be talking about what I need to do but I do not see these roles in SSMS 2008.

How do I go about setting this user up?
Question by:rwheeler23
  • 2
  • 2
LVL 21

Expert Comment

ID: 36926793
Job information is stored in the system database, msdb.  The roles are located in there.  



Expert Comment

ID: 36927804
As Greg said, you have to evoke those roles in MSDB databasse. here is the syntax... (put in your role choice and the right windows login)

use msdb
EXECUTE sp_addrolemember @rolename = 'SQLAgentReaderRole ', @membername = 'decla\jlu'

Author Comment

ID: 36928737
So their is no GUI interface to accomplish this? No wonder I could not find it.
LVL 21

Accepted Solution

JestersGrind earned 2000 total points
ID: 36930436
You can do it through the GUI.  Probably the easiest way to do it is to go into Security at the server level, then logins.  Open up the properties of the user that you want to add.  Under User Mapping, check the box next to the msdb database and then check the appropriate role in the lower pane.



Author Closing Comment

ID: 36932459
Right on the money.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
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…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

826 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