This is such pure Microsoft BS...I gave the SQL Server agent account full rights and it failed. But when I created a credential and proxy, it failed again. So I deleted the Proxy and Credential and changed the job to reflect the same, and now it seems to work just fine. This is some serious crap!