SQL 2000 - schedule jobs for 10 seconds?

This is SQL 2000. I have a SQL Script that i want to scheudle to run every 10 seconds.

Looked at the job scheduling and the least amount of time is 1 minute. What can I do? what are my other options??
LVL 8
CamilliaAsked:
Who is Participating?
 
Aaron ShiloConnect With a Mentor Chief Database ArchitectCommented:
hi use the SP to create the schedule

this sample will create a scedule for a every 10 seconds

EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'SCHEDULE',
            @enabled=1,
            @freq_type=4,
            @freq_interval=1,
            @freq_subday_type=2,
            @freq_subday_interval=10,
            @freq_relative_interval=0,
            @freq_recurrence_factor=0,
            @active_start_date=20070211,
            @active_end_date=99991231,
            @active_start_time=0,
            @active_end_time=235959
 
0
 
JoeNuvoConnect With a Mentor Commented:
For this requirement on the system I ever work with.

I combine job schedule with WAITFOR DELAY '000:00:10'
in the job, it will run 5-6 rounds of command together with WAITFOR DELAY (depend on how fast the query run)
0
 
CamilliaAuthor Commented:
Is this line says 10 seconds: @freq_subday_interval=10,

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.