• When you run it in Visual Studio, it runs as you. When it runs as a job, it runs as the SQL Server service account, or whatever proxy is configured for the purpose.

    John