SQL 2008 Jobs, Proxy, and Credentials

This is some what confusing...

SQL 2008 seems to be allow you to specify a proxy account to each STEP of a SQL Agent job as well as different proxies for different KINDS of job tasks, ie. SSIS, EXE, ActiveX, etc...

For example, the "owner" of a job has a step that runs a SSIS package. In order to do this, you will need to use or setup a SQL local account or domain account that has permissions to execute SSIS, then create a CREDENTIAL associated with that account on SQL server.

Next, you create a SSIS Proxy account and assign the credential to it. You also associate the "owner" to that Proxy.

Finally, in Properties of the job STEP, you assign the Proxy as the "Run as:" for the step that involves SSIS, in this example.

References:
http://support.microsoft.com/kb/918760
http://blogs.msdn.com/b/dataaccesstechnologies/archive/2009/10/13/who-owns-my-job-and-who-runs-it.aspx