You can also script this stuff out and then put it in to a job. SSIS might be overkill, depending on what you need.

Please show us some of what you've tried. What is difficult. We like to help, but we're not here to do all the work for you.