SQL Server Agent

Posted on 2011-04-25
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

    It will be created for security reasons

    Please look in to this :
    LVL 22

    Expert Comment

    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


    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 details about the proxy account.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now