One method is to schedule the proc execution using a SQL Server Agent job.
You can create a job using the EM or SSMS GUI.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"brogdonm" <Brogdons@gmail.com> wrote in message
news:1135034300.442082.324910@g14g2000cwa.googlegroups.com...
> Hi,
>
> I have this stored procedure that I need to run daily, how do I do
> this?
>
> Thanks,
> Mike
> <><
>