OR
create in a stored proc
create a DTS to run it
create and schedule a job in "management/SQL Server Agent/Jobs"
(The context menu of the DTS has an option to schedule the DTS)
ALSO
vb scripts can be scheduled
vbscripts can also execute stored procs on SQL Server
Comment