• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 373
  • Last Modified:

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??
2 Solutions
Aaron ShiloChief 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',
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)
CamilliaAuthor Commented:
Is this line says 10 seconds: @freq_subday_interval=10,

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.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now