Ola hollengren, DB maint script.

Don't reinvent the wheel.

Download.

Run script (it creates sql agent jobs)

Edit job step as needed (number of days to keep, target directory, etc)

Schedule job to run daily.

Miller time.