The account running your MSSQL service must have permissions to the file you are trying to access if you are running it as a job. When you execute it manually it is using access rights from the account you are currently logged in as.