Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Stairway to SQL Server Agent: Step 1: Setup and Overview Expand / Collapse
Author
Message
Posted Monday, February 14, 2011 10:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 30, 2014 11:41 AM
Points: 11, Visits: 62
Comments posted to this topic are about the item Stairway to SQL Server Agent: Step 1: Setup and Overview


Post #1063687
Posted Tuesday, March 8, 2011 11:36 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 13,368, Visits: 11,148
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...




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1075337
Posted Wednesday, March 9, 2011 12:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 6, 2011 12:31 AM
Points: 1, Visits: 9
thanks u very much for this article
Post #1075346
Posted Wednesday, March 9, 2011 2:32 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,416, Visits: 1,400
Will all the stairway articles later published in a book for collection? The articles are great...


Post #1075392
Posted Wednesday, March 9, 2011 6:01 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 7, 2014 3:52 AM
Points: 36, Visits: 198
Well written. Thanks!
Post #1075480
Posted Wednesday, March 9, 2011 8:06 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:52 AM
Points: 31,212, Visits: 15,656
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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1075579
Posted Wednesday, March 9, 2011 8:03 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 20, 2014 1:11 PM
Points: 27, Visits: 475
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
Post #1075978
Posted Thursday, March 10, 2011 8:47 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,416, Visits: 1,400
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...



Post #1076311
Posted Wednesday, August 24, 2011 1:47 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 28, 2014 7:58 AM
Points: 61, Visits: 122
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!
Post #1164463
Posted Wednesday, February 15, 2012 3:25 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 12:13 PM
Points: 130, Visits: 54
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.
Post #1252792
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse