This is if your using the client tools for SQL 2000 although they are very similiar in SQL 7.0
You need to create a scheduled job in Enterprise Manager. Make sure you have the appropriate Server permissions to accomplish this task.
Using Enterprise Manager go and open the Management Folder under the Server name. Check to see if SQL Server Agent is running. SOME THINGS TO CHECK - If not right click and choose properties and go to the General Tab. Check to see if the "Service startup account" is using the "This account" option w/ a valid domain account with Admin permissions. When done click OK. Right click again on the SQL Server Agent and check to see if it is running - the start option should be dimmed out. If its not running start it, also you should see a green arrow as part of the SQL Server agent icon in EM if it is running. NOTE: SQL Server Agent must be running to execute scheduled jobs
Expand out SQL Server Agent, find the Jobs icon and right click on it and then pick "New Job." On the General tab give a name to the job. Go to the Steps tab and click on the button at the bottom called New. Give the step a name. Then copy and paste your code to the command window. Click OK. Go to the Schedules tab and click on "New Schedule" button. Give the schedule a name and choose one of the scheduling option and click OK, click OK again and your done.