i used to do this by creating batch file using sqlcmd and will schedule it in the windows scheduler