Y, those are pretty simple DML operations, so either create an SP and run it in a job, or paste the query text directly into the job, or create a package. It's pretty straight forward...
which part are you having trouble with?
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
Minion Maintenance is FREE:
