<div>
Job information is stored in the system database, msdb. &nbsp;The roles are located in there. &nbsp;<br />
<br />
Greg<br />
<br />

</div>


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

Greg



<div>
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)<br />
<br />
use msdb<br />
EXECUTE sp_addrolemember @rolename = 'SQLAgentReaderRole ', @membername = 'decla\jlu'
</div>


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'

<div>
So their is no GUI interface to accomplish this? No wonder I could not find it.
</div>


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

<div>
<div class="content wysiwyg-content">
I need to allow a user the ability to submit and schedule jobs in SQL Server 2008 R2.<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms188283.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms188283.aspx</a>&nbsp; This artricle seems to be talking about what I need to do but I do not see these roles in SSMS 2008.<br />
<br />
How do I go about setting this user up?
</div>
</div>


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?

SQL Server 2008 Role to Submit Jobs

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.