November 4, 2009 at 9:29 pm
Our DBA quit and our IT department is scrambling to keep things running. The acting DBA asked me to figure out why some of the scheduled jobs are failing. I've never worked with SQL Agent before and need to get up to speed ASAP. We're running SQL 2008.
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.
Second, what role/permission do the jobs need to have to run?
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? 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?
Thanks in advance for any assistance.
Christian Bahnsen
November 4, 2009 at 10:47 pm
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
SNIP
Not sure how this post ended up in this thread..
November 5, 2009 at 6:29 am
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply