Post reply

Need to get up to speed on SQL Agent ASAP

  • November 4, 2009 at 10:47 pm

    #1075161

    Christian Bahnsen (11/4/2009)

    First, how would our acting DBA grant me permissions to see SQL Agent? I have SSMS 2008 but I don't see the SQL Agent node, so I can't see the scheduled jobs or which are failing. Is there a predefined role similar to dbo? I'm dead in the water until I can see the scheduled jobs and reverse engineer them.

    SQL Server 2008 Books Online (July 2009)

    ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/d728a2f5-6a2d-40f7-aba7-ed51b930072d.htm

    Second, what role/permission do the jobs need to have to run?

    I generally run all SQL jobs as the same login that SQL uses to login to the box.

    Third, I've been writing SSIS packages for a while now and running them in BIDS. What type of permissions do I need to deploy them to the SQL Server?

    BOL: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10is_4deptrbl/html/ca01311d-d987-4515-87e7-275c8fb185a8.htm

    Do the packages actually get stored in the SQL Server or is there just a pointer to a place in the file system where they reside?

    Yes.. Sorry, trying to be funny. The answer is that it can be either.

    CEWII

  • November 4, 2009 at 10:49 pm

    #1075163

    SNIP

    Not sure how this post ended up in this thread..

  • November 5, 2009 at 6:29 am

    #1075297

    Thanks for pointing me in the right direction. This was very helpful. Sorry if I chose the wrong subforum to post the question to.

Viewing 3 posts - 1 through 4 (of 4 total)

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