>how can i make the SQL Server execute a stored procedure every hour automatically???
>
>Thanks all
>Ricardo Martins
You can set up a Job under SQL Server Agent and execute it on any schedule you define. It's easiest to do this using Enterprise Manager.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao