So I had the SQL services failed over to the other node in our cluster in order to give the services a restart, and I decided to test something I've seen as an issue or perhaps bug, before. I tested the existing jobs, and they still failed with the same error messages. Then I created some new ones and these worked as intended.