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

  • Richard Waymire

    SSC Eights!

    Points: 917

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

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    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

  • khaleel_zourob

    Grasshopper

    Points: 17

    thanks u very much for this article

  • Anipaul

    SSC-Insane

    Points: 24681

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

  • la5794

    SSC Enthusiast

    Points: 138

    Well written. Thanks!

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 718163

    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

  • jswong05

    Hall of Fame

    Points: 3503

    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
    😛

  • Anipaul

    SSC-Insane

    Points: 24681

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

  • neil.mcdonnell1967

    SSC Enthusiast

    Points: 130

    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!

  • PavlovsMouse

    SSC Veteran

    Points: 234

    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.

  • david.shink

    SSC Enthusiast

    Points: 181

    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

  • richlion2

    SSCrazy

    Points: 2479

    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

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 718163

    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 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply