InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 01:52:01 GMT20http://www.sqlservercentral.com/Forums/Topic1190968-2905-1.aspxExcellent article, great job.[i][b]qh[/b][/i]Tue, 13 Mar 2012 05:53:26 GMTquackhandle1975http://www.sqlservercentral.com/Forums/Topic1190968-2905-1.aspxThe SQL Server Agent service account will definately need enough rights to restart the service, I just don't know if that's full administrator rights. For some reason this limitation is not mentioned in the considerations for not using an administrative service account in books online.Wed, 25 Jan 2012 07:54:46 GMTRichard Waymirehttp://www.sqlservercentral.com/Forums/Topic1190968-2905-1.aspxIn past versions of SQL Server, the SQL Server Agent service account needed Windows Administrator rights on the local computer in order to successfully restart the service when it stops unexpectedly (because the SQL Server Service would have to be restarted first). Is that still true in SQL Server 2008? 2012?Thanks.Sun, 22 Jan 2012 09:03:26 GMTDr. Diana Deehttp://www.sqlservercentral.com/Forums/Topic1190968-2905-1.aspxYes, unfortunately although these roles exist for the most part you need to be a sysadmin or the job owner to do anything useful.Wed, 11 Jan 2012 16:06:05 GMTRichard Waymirehttp://www.sqlservercentral.com/Forums/Topic1190968-2905-1.aspxI think its worth noting here that even members of SQAgentoperatorRole cannot modify or delete jobs they do not own.This limitation unfortunately prevents granting the right to someone to fully manage all jobs without granting them sysadmin.Wed, 11 Jan 2012 16:04:36 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1190968-2905-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/72460/">Stairway to SQL Server Agent - Level 9: Understanding Jobs and Security</A>[/B]Sat, 15 Oct 2011 15:07:10 GMTRichard Waymire