I have an SQL Job which processes minimum amount of rows at a given time. Currently its running every 10 seconds which is the minimum available in Job Scheduler. But because of that the table used processed by the Job gets filled with many records. So I need to run the job every 1 second. How can achieve this? please advice.
Create a job that is scheduled to start every minute. Have the job do something like:
WHILE 1=1 BEGIN EXEC dbo.SomeProcedure; /* this would be the name of a stored procedure that does the actual work */ WAITFOR DELAY '00:00:01.000'; END
Thanks to Max Vernon, who gave me this answer earlier.