Am gonna add 2 cents to this as in the past and with older versions of moodle that did not have adhoc task, I had to create an auto backup system of my own ... using the backup.php script which you have already used and know it will work.
My brief 'sad story' concerning auto backups - HS Moodle - many course backups were large ... 1 in particular ... course was in digital media - everything/anything digital - photography, audio, video and then some.
Had auto back ups set to designated directory ... outside of moodledata/filedir/ ... when cron ran auto, it would never complete past that dig media course ... discovered that ... backed it up via command line ... it did complete! at the time that backup was about 120+ GIG.
So ... turned of auto backup ... truncated any table related to auto ... did a query of database looking only for .mbz files and sorted by size of file. That allowed me to determine which courses would be backed up via command line via bash shell script on Sunday .... all day Sunday!
Had 3 such scripts that looped through a smallcids.txt (cids=course id numbers only) file, a mediumcids.txt file, and a largecids.txt file (only 3 courses including that DM course) and used the admin/cli/backup.php script that pointed to a designated directory.
All that to say ... depending upon how large your courses are and if you can ever get auto to work as it should ... will be only to glad to share how I did above.
'SoS', Ken