How can you create a daily schedule for DB Dump?

SUGGESTED

Hi Forum,

I have created a macro that automatically dumps my company databases but my challenge is HOW to attach this to a scheduler like "Task Scheduler" and make it run successfully. When I tried creating the task and thought I had done everything right it just didn't work. Can someone help please ??