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)
 How to use schedular

Author  Topic 

Swati Jain
Posting Yak Master

139 Posts

Posted - 2006-09-20 : 01:15:05
How to create a Stored Procedure and use schedular to call it after every 2 minutes depending on the total number of records.
How to access t at the front end

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-09-20 : 01:38:37
What are you trying to do??

There might be an easier way to go about it.
Go to Top of Page

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-09-20 : 02:56:16
what you are asking, its better to acheive via front end. Since there is control called TIMER in most of the programming language,
which will do the trick for you..

I guess, you should create the procedure,and call from the front end after every x mins.

Chirag
Go to Top of Page

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-09-20 : 17:48:09
Or create a service that does the same thing (so it can run even when no-one is connected)

Tim
Go to Top of Page
   

- Advertisement -