Scheduling a job more frequently than every minute

I have a SQL Agent job that is scheduled to run every minute. Works like a
charm, however, my client would like it to run more frequently, like every 15
seconds. I'm pretty sure this cannot be scheduled in the SQL Agent, but I'm
equally sure it can be done. I just don't know the right verbiage or
commands to use or how to execute it. Any help would be greatly appreciated.
Thanks in advance.
d
http://sqldev.net/sqlagent/SQLAgentRecuringJobsInSecs.htm
Above is for 2000. I haven't tried it on 2005.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Darlene Mack" <DarleneMack@.discussions.microsoft.com> wrote in message
news:0A8AD7BE-245F-4912-8FC5-9BDE45D389A1@.microsoft.com...
>I have a SQL Agent job that is scheduled to run every minute. Works like a
> charm, however, my client would like it to run more frequently, like every 15
> seconds. I'm pretty sure this cannot be scheduled in the SQL Agent, but I'm
> equally sure it can be done. I just don't know the right verbiage or
> commands to use or how to execute it. Any help would be greatly appreciated.
> Thanks in advance.
>
> d
|||Thanks!!!!
"Tibor Karaszi" wrote:

> http://sqldev.net/sqlagent/SQLAgentRecuringJobsInSecs.htm
> Above is for 2000. I haven't tried it on 2005.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Darlene Mack" <DarleneMack@.discussions.microsoft.com> wrote in message
> news:0A8AD7BE-245F-4912-8FC5-9BDE45D389A1@.microsoft.com...
>
>