Can Job Frequency go less than one minute?

Hi,
I'd like to schedule a job on my utility server to run every 15 seconds. Is
it possible to do that in SQL Agent?
Thanks,
What kind of task is it ?
Message posted via http://www.droptable.com
|||You create on job and loop this job with issuing a wait statement for the
time the job didnt take place.
WAITFOR DELAY '000:00:15'
OR evaluating the time when the last start took and ended and substract that
from the 15 seconds.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Kam" <Kam@.discussions.microsoft.com> schrieb im Newsbeitrag
news:9EA7C3C3-10BC-48C9-9B84-7AF4F9891E56@.microsoft.com...
> Hi,
> I'd like to schedule a job on my utility server to run every 15 seconds.
> Is
> it possible to do that in SQL Agent?
> Thanks,
|||Have a look at http://sqldev.net/sqlagent/SQLAgentR...JobsInSecs.htm
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:9EA7C3C3-10BC-48C9-9B84-7AF4F9891E56@.microsoft.com...
> Hi,
> I'd like to schedule a job on my utility server to run every 15 seconds.
> Is
> it possible to do that in SQL Agent?
> Thanks,

Can Job Frequency go less than one minute?

Hi,
I'd like to schedule a job on my utility server to run every 15 seconds. Is
it possible to do that in SQL Agent?
Thanks,What kind of task is it ?
Message posted via http://www.droptable.com|||You create on job and loop this job with issuing a wait statement for the
time the job didnt take place.
WAITFOR DELAY '000:00:15'
OR evaluating the time when the last start took and ended and substract that
from the 15 seconds.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Kam" <Kam@.discussions.microsoft.com> schrieb im Newsbeitrag
news:9EA7C3C3-10BC-48C9-9B84-7AF4F9891E56@.microsoft.com...
> Hi,
> I'd like to schedule a job on my utility server to run every 15 seconds.
> Is
> it possible to do that in SQL Agent?
> Thanks,|||Have a look at http://sqldev.net/sqlagent/SQLAgent...gJobsInSecs.htm
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:9EA7C3C3-10BC-48C9-9B84-7AF4F9891E56@.microsoft.com...
> Hi,
> I'd like to schedule a job on my utility server to run every 15 seconds.
> Is
> it possible to do that in SQL Agent?
> Thanks,