July 11, 2011 at 9:50 am
I have a dev sql 2008 server with a job I have created that runs an SSIS package for a vendor. I needed to run the step as the user account which is is the owner of the job(which is sysadmin on the box and sql server). However when I create the job on the job step I select the drop down for the "Run As" i only get sql agent as a selection?
July 11, 2011 at 10:49 am
You have to add agents to the SQL Agent set up.
You do that through the Proxies tab. You'll have to set up a Credential first (server security).
As an aside, your post makes it sound like you're running a production process through Dev Edition to me. Is that correct? If so, move it off of Dev Edition ASAP.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply