Please post int he appropriate forum. There are forums for 2000 questions. Moving this thread.

You would need to use SQL Agent to schedule this as well.

If you read up on this and make a try and still have specific questions, we are happy to help.