SQL Server Agent
Posted on 2011-04-25
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.