Anyone know a tricky way to get a job to fire more frequent than every minute?
I would like to have an action, trigger the job, but the application login does not own the job and am having problems. Here's what you run into if the application login tries to do this: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q201021&VOTE=1
I am running SQL 7 SP1 on NT 4 SP6a.
You can create a stored procedure that uses a WAITFOR DELAY and set it up with a delay of what ever seconds you want. Then use the stored procedure sp_procoption to set the new procedure you created to startup automatically when SQL Server starts. I don't know if this is what you are looking for, but I'd be hesitant on the CPU utilization of the job.