• Here is the script that i found ..

    http://www.nilkanth.com/2004/07/18/sql-jobs-auto-backup/

    Then put this script in a job and schedule it to receive the output .

    Regards,
    Kumar