Solved

SQL 2000 - schedule jobs for 10 seconds?

Posted on 2011-03-19
3
346 Views
Last Modified: 2012-05-11
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??
0
Comment
Question by:Camillia
3 Comments
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 250 total points
ID: 35171783
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
 
LVL 11

Assisted Solution

by:JoeNuvo
JoeNuvo earned 250 total points
ID: 35171801
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
 
LVL 7

Author Comment

by:Camillia
ID: 35172341
Is this line says 10 seconds: @freq_subday_interval=10,

0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now