Schedule job for 30 seconds?

[RRinTetons]

I have a *tiny* job I want to have run every 30 seconds. Actually, I'd like to use a trigger, but it's a vendor-supplied db and I stepped on something in their code when I tried to add a trigger to one of their tables. So, I wrote a tiny little SP that executes in a few milliseconds. I can schedule it for every minute and run it just fine, but to server its purpose really properly it needs to run every 30 seconds or so.

There seems to be no way to do that through the job scheduling interface, and it appears the system sp to create a schedule won't take a frequency setting of less than 1 minute, either. Is there a way to do this?

If I can't do it from the SQL Server job system I might be able to do it from a .cmd run on an OS schedule using osql; any thoughts on that?

-
Richard Ray
Jackson Hole Mountain Resort

 

[Jamfool]

1 min is smallest frequency you can set in job agent.

Therefore you can either do this externally via a custom schedule or you could do something like:

BEGIN
WAITFOR DELAY '00:00:30';
SELECT 1;
END;
GO