hai

how i can shcedule a stored procedure which i needs to run for every 10 sec. can any one help me to get out of this problem.

                                                    thanks
                                                     Vamsi



vamsi

__________________
vamsi Krishna G
mobile: 91 + 9986023966.
124 Puttappa layout new Tippasandhra,
bangalore.
Inida

Go into Enterpise Manager
Open the SQL Server Agent node
Go to jobs.. create a new job

Jim

A little more detail: Go to sqlserver agent, select jobs, rightclick and select new job, under General/description write exec (store procedure name), then click on schedule/new schedule and set it up for every 10 minutes.

      thanks for u r help. I have one more problem. How can i schedule it for 5 sec. i.e., less than a minute. is there any option to do that


vamsi

I don't see a way of setting it for less than 1 min

can't we do it through sql query or through any other process.

thanks
vamsi

vamsi

You can add a job and schedule it though system stored procedures, but you still can't set the timing for less than 1 minute.

thanks for u r help. I need to search an other to handle this.

regards
vamsi

vamsi

no problem :)

Hi.

You could try to set up several schedules on the same job, setting each schedule to run every minute, with different starting points. One could start say 05:00:00 , the next could start 05:00:10. Continue like that until you have the minute covered.

Might be a problem though, if the jobs can not run at the same time, since you are not guaranteed that the last job has finished.

gert