Add a new SQL Agent Job with appropriate TSQL Statements to automate the same with a particular schedule

For more info refer the below

http://social.technet.microsoft.com/Forums/en-US/sqldatabaseengine/thread/4b0feb75-c1dc-43a9-b628-c7ebc96be598/