Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 automatic SP

Author  Topic 

lane0618
Posting Yak Master

134 Posts

Posted - 2002-06-11 : 20:25:31
Is it possible to run a stored procedure once a day automatically?

Thanks,
Lane

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-06-11 : 20:29:50
Hi

Yes, just set up a scheduled task that has a SQL step.
You can either find it in books online or poke around in Enterprise Manager. Setting up a job is pretty intuitive actually so you should have too many hassles.

Damian
Go to Top of Page
   

- Advertisement -