When the process is ran by a job, is the job step using a credential to run? If so it could be an account different from the one the Agent service uses. According to Books Online, " In SQL Server 2005 Database Engine, maintenance plans create an Integration Services package, which is run by a SQL Server Agent job. " Could this explain why it works under one method and not the other?