For exemple, i want to execute it every 5 minutes from 8 AM to 20 PM
ThanksSQL Agent provides scheduled execution times etc. you can use to do such things.
Right click on the Agent node in Management Studio, select new job. Select the schedule tab and note that there are ways to schedule a job daily, and then sub obtions allow you to execute every x minutes or hours.|||
Great ! it works fine
|||Out of interest, what is it actually doing?I'm just thinking that in some circumstances maybe it might be better to execute a package when some event occurs rather than continuously executing at defined intervals waiting for something to happen (if indeed this is what it is doing).
Another option might be the WMI EventWatcher task.
Just speculating of course...
-Jamie|||I use it to download stock quotes published on http server...|||Fair enough. SQL Agent is probably your best option then. I'll shutup now
|||
ps : excuse my french accent...|||
Coroebus wrote:
I'm beginner then i listen everyone... your remarks are welcome....
ps : excuse my french accent...
Your english is alot better than that of other people I have seen on many technical forums that speak it as their first language. Don't worry about that!
No comments:
Post a Comment