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 Administration (2000)
 how to run an procedure automatically

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-04-28 : 14:03:15
prabu writes "hello Team,

I am having a problem in running my stored procedure. What is the query to run an stored procedure automaticaly every day, can any one help me with this.
pls"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-04-28 : 14:04:59
You can schedule a stored procedure to run everyday using the SQL Server Agent scheduler. You can add a job via Enterprise Manager or using sp_add_job.

Tara
Go to Top of Page
   

- Advertisement -