Home All Groups Group Topic Archive Search About
Author
26 May 2005 1:50 PM
tarpan
Hi, I want to start my SP on timer, let's say every minute.

Is it possible to do in MS SQL Server internally?
If not, what is the simplest way to do this?

Thanks

Author
26 May 2005 1:58 PM
JT
Schedule a Job.

Show quoteHide quote
"tarpan" <tar***@discussions.microsoft.com> wrote in message
news:73494B8B-C415-4618-A03A-82969EFB36D6@microsoft.com...
> Hi, I want to start my SP on timer, let's say every minute.
>
> Is it possible to do in MS SQL Server internally?
> If not, what is the simplest way to do this?
>
> Thanks
Are all your drivers up to date? click for free checkup

Author
26 May 2005 2:02 PM
Raymond D'Anjou
Create a job that will run the SP every minute.
You can use Enterprise Manager to do this.

Show quoteHide quote
"tarpan" <tar***@discussions.microsoft.com> wrote in message
news:73494B8B-C415-4618-A03A-82969EFB36D6@microsoft.com...
> Hi, I want to start my SP on timer, let's say every minute.
>
> Is it possible to do in MS SQL Server internally?
> If not, what is the simplest way to do this?
>
> Thanks

Bookmark and Share