I found the issue in the actual SQL Agent Job. I had imported the job from another server and I overrode the data source. Once I found that and fixed it it worked correctly.