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)
 need to run a proc at a given time

Author  Topic 

aa_mm_aa_nn
Starting Member

2 Posts

Posted - 2004-03-22 : 13:39:38
Can anyone tell me how to run a proc at a set time..

i mean i want this proc to run every night at 11pm..

how can i do this??

thanks a lot

NPR
Starting Member

15 Posts

Posted - 2004-03-22 : 13:43:07
Setup a job to run the proc every night. In Enterprise manager it is under the management folder then SQL Server Agent and then finally you will see jobs. Just set up a job to run the proc at a specific time and it will run it every night for you.
Go to Top of Page

aa_mm_aa_nn
Starting Member

2 Posts

Posted - 2004-03-22 : 13:50:56
thanks
i am new to this so i will work on it..
but i got the direction to go in..
thanks
Go to Top of Page
   

- Advertisement -