This script will create an SQL Server Agent job, which will take daily database backup to a folder with date appended in the filename.