Stairway to SQL Server Agent: Level 1: Setup and Overview

  • Comments posted to this topic are about the item Stairway to SQL Server Agent: Level 1: Setup and Overview

  • 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

  • thanks u very much for this article

  • Will all the stairway articles later published in a book for collection? The articles are great...

  • Well written. Thanks!

  • 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

  • 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)

  • 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...

  • 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!

  • 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.

  • 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

  • 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

  • richlion2 - Wednesday, January 10, 2018 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

    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