InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 00:22:45 GMT20http://www.sqlservercentral.com/Forums/Topic1063687-2905-1.aspxWhile mentioning the options for the service account that sql agent runs under, it bears mentioning that it is strongly recommended to use a named account in the domain to run the service. While the network services account has some limited network privileges, it is impossible to assign explicit permissions to the Network Services internal account. So if you do need to run ETL pulling data from a fileshare, or do anything that involves touching a networked resource, you will probably hit a brick wall with the Network Services account.Wed, 15 Feb 2012 15:25:55 GMTPavlovsMousehttp://www.sqlservercentral.com/Forums/Topic1063687-2905-1.aspxGood stuff, I'm in a position where we have just had ouir DBA leave so I'm having to get up to speed PDQ! These articles seem perfect!Wed, 24 Aug 2011 01:47:43 GMTneil.mcdonnell1967http://www.sqlservercentral.com/Forums/Topic1063687-2905-1.aspx[quote][b]Steve Jones - SSC Editor (3/9/2011)[/b][hr][quote][b]Anipaul (3/9/2011)[/b][hr]Will all the stairway articles later published in a book for collection? The articles are great...[/quote]This is probably what we will do when they are completed. So once we get all the SQL Agent articles, it will probably be a mini book[/quote]Great Idea!!! This will be very nice...Thu, 10 Mar 2011 08:47:08 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic1063687-2905-1.aspxMany authors (books) wrote about how to set up SQL Server agent and jobs. Many forgot to mention setting up the "clean up" part which is equally important. There is also a SP "sp_purge_jobhistory" you can use.Nice summary article, like a BOL style documentation. Thanks for taking time to write (revisit) this topic. (maybe the 30th times on the web)Wed, 09 Mar 2011 20:03:44 GMTjswong05http://www.sqlservercentral.com/Forums/Topic1063687-2905-1.aspx[quote][b]Anipaul (3/9/2011)[/b][hr]Will all the stairway articles later published in a book for collection? The articles are great...[/quote]This is probably what we will do when they are completed. So once we get all the SQL Agent articles, it will probably be a mini bookWed, 09 Mar 2011 08:06:18 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1063687-2905-1.aspxWell written. Thanks!Wed, 09 Mar 2011 06:01:26 GMTla5794http://www.sqlservercentral.com/Forums/Topic1063687-2905-1.aspxWill all the stairway articles later published in a book for collection? The articles are great...Wed, 09 Mar 2011 02:32:26 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic1063687-2905-1.aspxthanks u very much for this articleWed, 09 Mar 2011 00:24:08 GMTkhaleel_zourobhttp://www.sqlservercentral.com/Forums/Topic1063687-2905-1.aspxNice article, but in my opinion a bit too much focused on DBA's. There are other people who use SQL Server Agent too :-)For example, scheduling the entire ETL flow to populate a data warehouse through SSIS packages.But it looks like a good start of a great staircase...Tue, 08 Mar 2011 23:36:16 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1063687-2905-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/72267/">Stairway to SQL Server Agent: Step 1: Setup and Overview</A>[/B]Mon, 14 Feb 2011 10:37:08 GMTRichard Waymire