SQL Server Agent

Posted on 2011-04-25
Medium Priority
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.
Question by:SeTech
LVL 21

Accepted Solution

Alpesh Patel earned 2000 total points
ID: 35459271
It will be created for security reasons

Please look in to this :http://msdn.microsoft.com/en-us/library/ms189064.aspx
LVL 22

Expert Comment

ID: 35459705
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.
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 35463743

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.


Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question