SQL Server 2008 Role to Submit Jobs

Posted on 2011-10-06
Last Modified: 2012-08-13
I need to allow a user the ability to submit and schedule jobs in SQL Server 2008 R2.  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
    LVL 21

    Expert Comment

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


    LVL 5

    Expert Comment

    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

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

    Accepted Solution

    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

    Right on the money.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now