Check out the topic
How to create a job (Enterprise Manager) in the SQL Server Books Online. Don't forget to follow the like to
Creating Job Steps. You want to use a Transact-SQL Job Step.
-Mike
>Can someone tell me how to setup SQL Agent to run a stored procedured at a given interval?
>
>Thanks
>Kirk