If your PC is missing backups when in 'Sleep' state then you may need to adjust a setting in your active 'Power Plan' to enable the Windows Task Scheduler to wake up the PC:
If 'Run task as soon as possible after a scheduled task is missedIf missed then run at the next startup' is un-checked then the last status of scheduled tasks will show 0x800710E0 otherwise the task will run the next time the PC is woken or restarted.
...