We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SQL Server Agent

SeTech
SeTech asked
on
Medium Priority
469 Views
Last Modified: 2013-11-10
When I schedule a job using SQL Server Agent in SSMS for SQL 2008 where I want to scheulde the run of a SSIS package. In the General Tab I:
1. Name the Step
2. Type is SQL Sequel Server Agent Package
3. Run as is a Proxy that I set up in the Credential folder in Security (SSMS).
The package runs and I got the above by trial and error as well as reading some Books Online. So again the package runs, but my igorance remains in regards to why do I need to set up a proxy account when I thought I could use my own ID. Does it have to do with "where" things are located. In other words, BIDS is on my machine and I connect to a remote server? Hate to seem dumb, however the enviorment in my office is that some people have left that assisted on this and a lot of projects here are on a "I need it yesterday and I will give you the real instuctions on what I need tomorrow" Therefore its is often a situation of just get it done, if  you know what I mean.
Thanks
Comment
Watch Question

Solution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
The use of the proxy account is a Best Practice because, at some point, you may not be the one running the package (hey, you might get a job offer at twice the salary and requiring that you work from home, right? ;-).  Also, if you get in the habit of using the proxy, then, when you start deploying packages to a server, you will not have to remember that, on the server, you probably won't be logged in all the time and the SQL Agent will need to execute the packages.
Jason YousefSr. BI  Developer

Commented:
Hello,

When SQL Server Agent runs its tasks it normally does so using the context of the service account you assigned to the Agent service. This may or may not be the best context for your application, so you can set up a Proxy. This allows you to run the task under the context of the account you set up in the proxy, and it's pretty easy to do.

There's a good article about that..in details about the proxy account.

http://www.codeproject.com/KB/database/SQL_Server_Agent_Proxy.aspx
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.