It was not a permission problem. It was a problem with limited space on the server. I save my backups to cloud storage, but but there was not enough available space on my site for the backup to complete before saving the backup elsewhere. My host has increased my space and the backup now works.
I ran the backup again today and it worked. I always select tar GZip for archive format. In the jobs which failed, I hadn’t selected any specific compression under the db option. Today I did and selected GZip compression under database. I don’t know if that made a difference or not. I had also alerted my host of the issue and it is possible he noticed the permission issue and corrected it.