We now have a couple dozen sites we maintain for ourselves and various clients. Some of the normal routine tasks are becoming quite cumbersome.

Is there a way to automate via cron

Database Backup - MySQL
Then in Store Manager the Activity Log and Optimize Database commands?

Thanks
JOhn ><>