SQLServerCentral.com / Article Discussions / Article Discussions by Author / Discuss content posted by Richard Waymire / Stairway to SQL Server Agent: Step 1: Setup and Overview / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 31 Mar 2015 12:43:39 GMT20RE: Stairway to SQL Server Agent: Step 1: Setup and Overviewhttp://www.sqlservercentral.com/Forums/Topic1063687-2905-1.aspxI am just seeing this post now (7/15/13). It is a good 1st step to what looks like a very useful staircase. I am an Oracle DBA who has occasionally had to manage SQL Server instances. This post will actually help me in my day to day work. I am looking forward to the rest of this series. David ShinkMon, 15 Jul 2013 11:11:44 GMTdavid.shinkRE: Stairway to SQL Server Agent: Step 1: Setup and Overviewhttp://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 GMTPavlovsMouseRE: Stairway to SQL Server Agent: Step 1: Setup and Overviewhttp://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.mcdonnell1967RE: Stairway to SQL Server Agent: Step 1: Setup and Overviewhttp://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 GMTAnipaulRE: Stairway to SQL Server Agent: Step 1: Setup and Overviewhttp://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 GMTjswong05RE: Stairway to SQL Server Agent: Step 1: Setup and Overviewhttp://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 EditorRE: Stairway to SQL Server Agent: Step 1: Setup and Overviewhttp://www.sqlservercentral.com/Forums/Topic1063687-2905-1.aspxWell written. Thanks!Wed, 09 Mar 2011 06:01:26 GMTla5794RE: Stairway to SQL Server Agent: Step 1: Setup and Overviewhttp://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 GMTAnipaulRE: Stairway to SQL Server Agent: Step 1: Setup and Overviewhttp://www.sqlservercentral.com/Forums/Topic1063687-2905-1.aspxthanks u very much for this articleWed, 09 Mar 2011 00:24:08 GMTkhaleel_zourobRE: Stairway to SQL Server Agent: Step 1: Setup and Overviewhttp://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 VerbeeckStairway to SQL Server Agent: Step 1: Setup and Overviewhttp://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