<div>
In theory you could set up a stored procedure that called the sp_change_job, and use EXECUTE AS to make it run under a sysadmin user, then just GRANT them execute on just that stored proc, but I've never had any luck getting all that to actually work (or work well).
</div>


In theory you could set up a stored procedure that called the sp_change_job, and use EXECUTE AS to make it run under a sysadmin user, then just GRANT them execute on just that stored proc, but I've never had any luck getting all that to actually work (or work well).

<div>
This can be achieved using the SQLAgentOperatorRole in MSDB. &nbsp;Refer to the following articles:<br />
<br />
<b>Explanations of SQLAgent*Roles</b><br />
<a href="http://msdn.microsoft.com/en-us/library/ms188283.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms188283.aspx</a><br />
<br />
<b>Configure a user to create and manage SQL Server Agent Jobs</b><br />
<a href="http://msdn.microsoft.com/en-us/library/ms187901.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms187901.aspx</a>
</div>


This can be achieved using the SQLAgentOperatorRole in MSDB.  Refer to the following articles:

Explanations of SQLAgent*Roles
http://msdn.microsoft.com/en-us/library/ms188283.aspx [http://msdn.microsoft.com/en-us/library/ms188283.aspx]

Configure a user to create and manage SQL Server Agent Jobs
http://msdn.microsoft.com/en-us/library/ms187901.aspx [http://msdn.microsoft.com/en-us/library/ms187901.aspx]

<div>
&gt;&gt; This can be achieved using the SQLAgentOperatorRole in MSDB. &lt;&lt;<br />
<br />
Don't think so. &nbsp;Not to *edit* another users' job(s).
</div>


>> This can be achieved using the SQLAgentOperatorRole in MSDB. <<

Don't think so.  Not to *edit* another users' job(s).

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Can someone please advise me how i can grant a windows group &nbsp;to be able to edit<br />
&nbsp;sql agent jobs created by a certain user without providing it syadmin permissions.<br />
<br />
Thanks.
</div>
</div>


Hi,

Can someone please advise me how i can grant a windows group  to be able to edit
 sql agent jobs created by a certain user without providing it syadmin permissions.

Thanks.

permission to grant to a windows group  to edit sql agent jobs created by another user

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.