| Bruce de Freitas 2002-11-20, 3:23 pm |
| Well... you COULD have a loop in a proc, and use the
WAITFOR command which does a pause for the time you
specify, then it'll continue on...
If you're trying to do some type of alert, like a file
existence check(?), might want to look at firing an alert
instead of checking whatever you're checking, every few
seconds... Bruce
>-----Original Message-----
>Hi all. I would like to schedule a job to run every ten
>seconds in sql server. How can I do this? The Job
>scheduler will only go as fast as once per minute. I am
>currently doing this with a VB app, but I want to do this
>through SQL server. Please help.
>
>Thanks,
>Chris
>.
>
|