February 14, 2011 at 10:37 am
Comments posted to this topic are about the item Stairway to SQL Server Agent: Level 1: Setup and Overview
March 8, 2011 at 11:36 pm
Nice 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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2011 at 12:24 am
thanks u very much for this article
March 9, 2011 at 2:32 am
Will all the stairway articles later published in a book for collection? The articles are great...
March 9, 2011 at 6:01 am
Well written. Thanks!
March 9, 2011 at 8:06 am
Anipaul (3/9/2011)
Will all the stairway articles later published in a book for collection? The articles are great...
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
March 9, 2011 at 8:03 pm
Many 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)
Jason
http://dbace.us
😛
March 10, 2011 at 8:47 am
Steve Jones - SSC Editor (3/9/2011)
Anipaul (3/9/2011)
Will all the stairway articles later published in a book for collection? The articles are great...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
Great Idea!!! This will be very nice...
August 24, 2011 at 1:47 am
Good 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!
February 15, 2012 at 3:25 pm
While 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.
July 15, 2013 at 11:11 am
I 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 Shink
January 10, 2018 at 8:29 am
I'd like to thank the author for such a well organized set of articles. Although I know quite a lot about SQL-Server however finding a good simple tutorial can be sometimes cumbersome. It kind of organizes what I don't know and know all together, especially when one inherits an existing system someone else has setup and there aren't many chances to start a system from scratch.
Richard
January 10, 2018 at 9:53 am
richlion2 - Wednesday, January 10, 2018 8:29 AMI'd like to thank the author for such a well organized set of articles. Although I know quite a lot about SQL-Server however finding a good simple tutorial can be sometimes cumbersome. It kind of organizes what I don't know and know all together, especially when one inherits an existing system someone else has setup and there aren't many chances to start a system from scratch.Richard
Glad you like these. Feel free to spread the word 🙂
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply